Hello,Is there any way to list the software installed on a computer on a single row? I want to avoid having duplicate "computers" for each software installed... I end up having thousands of lines instead one line per each computer with all software i...

Hello,I'm trying to select only computers with specific names. My query is like this:select ...tablesFROM tblAssetsinner join inner joinWHERE (tblAsset.AssetName = '%AAA%' or tblAsset.AssetName = '%BBB%' or tblAsset.AssetName = '%BBB%') ..... I do 6 ...

Hello,I'm trying to build a report.. but I have some issues like double rows for computers with two monitors or two Microsoft Office versions. I would like to create a new column for second monitor and second Microsoft Office software, also in my rep...