Report to list all assets not in an asset group

[MikeInLa]

Can someone help me with a report that will list all assets that do not belong to an asset group? Would like it to show: IP Location; Computer Name, Asset Type, O/S

[MikeInLa]

Perfect! Thanks 🙂

[Hemoco · Accepted solution]

Please use the report below for the information you are after.

select Top 1000000 tsysAssetTypes.AssetTypeIcon16 As icon,
tsysIPLocations.IPLocation,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblOperatingsystem.Caption As [operating system]
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Left Join tblOperatingsystem On tblAssets.AssetID = tblOperatingsystem.AssetID
Left Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Left Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssets.AssetID Not In (Select Top 1000000 tblAssets.AssetID
From tblAssets Left Join tblAssetGroupLink On tblAssetGroupLink.AssetID =
tblAssets.AssetID Left Join tblAssetGroups On tblAssetGroups.AssetGroupID
= tblAssetGroupLink.AssetGroupID
Where tblAssetGroups.AssetGroup Not Like '%default%group%' Group By
tblAssets.AssetID Having count(*) > 0)


To use the report above, do the following:
• Open the report builder under Reports/Create New Report.
• Paste the SQL code we provided at the bottom of the page.
• Left-click somewhere in the upper section of the page so the code applies.
• Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.