Custom Inventory audit report

[Ben_Rutherford]

I am trying to generate essentially an Audit Report
The below is what we have so far, But i would like to add:

- Free Disk space on the C: in GB
- If Parallels Client 64 bit is installed and What version
- the username of local admin account
- and installed version of MS office

I am fairly new to this and am just wondering if someone is able to assist with this -


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysOS.OSname As OS,
tblAssets.OScode + '.' + tblAssets.BuildNumber As Build,
tblAssets.Version As [OS Version],
tblAssets.IPAddress As [IP Adress],
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Location,
tblFloppy.Model As SSD
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Outer Join tsysIPLocations On tblAssets.LocationID =
tsysIPLocations.LocationID
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
Where (tsysOS.OSname = 'Win 10' And tblAssetCustom.State = 1 And
tblAssets.BuildNumber Is Not Null And
Cast(Replace(Replace(Replace(tblAssets.OScode, '.', ''), 'S', ''), 'R',
'') As int) Not In (Select Max(Cast(Replace(Replace(Replace(tsysOS.OScode,
'.', ''), 'S', ''), 'R', '') As int)) As Expr1 From tsysOS
Where tsysOS.Sortorder = 18)) Or
(tsysOS.OSname = 'Win 10' And tblAssetCustom.State = 1 And
tblAssets.BuildNumber Is Not Null And tblAssets.BuildNumber Not In (Select
Max(tblAssets.BuildNumber) As Expr1 From tblAssets
Where Cast(Replace(Replace(Replace(tblAssets.OScode, '.', ''), 'S', ''),
'R', '') As int) In (Select
Max(Cast(Replace(Replace(Replace(tsysOS.OScode, '.', ''), 'S',
''), 'R', '') As int)) As Expr1 From tsysOS
Where tsysOS.Sortorder = 18)))
Order By tblAssets.AssetName

[Esben_D]

First thing I would say, just for easy of use is don't try to push everything in 1 report, its easier to have separate ones unless you really need to (or have the SQL knowledge).

Some of the things you need are already present in built-in report which you can modify slight.
Free space and local admin both have built-in reports, although they might require some editing if you specifically only need what you've listed.

For software, there is a built-in Windows software report, where you can pretty easily add a condition for the software name to give you all the versions of a software.

For 32 or 64 bit, it depends on the software. Some software has that info in the name, which makes it easy. If not you can check if this info is in a registry key that you can scan, or, you can scan the executable with file scanning and do a count on the 32 bit and 64 bit executable.