cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
eis-sps-support
Engaged Sweeper
I am trying to figure out how to add the column for static group name to any (and all reports) we have multiple departments that use Lansweeper and we need an easy way to sort each department's machines Dynamic groups don't work perfectly so we're willing to manually add them to the static groups we created but then we need the reports to be filtered on those static groups. Can someone help me out with the context I'd need to add to each existing report to give me this column?
1 REPLY 1
rwallace75
Engaged Sweeper
I am trying to do this also. I just want a report that I currently use for checking windows update status to include AssetGroup column. I have added the tblAssetGroupLink table but no luck so far. My script is listed below.

The report runs but does not include the AssetGroup column.

Code:

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
Max(tblQuickFixEngineering.Lastchanged) As LastPatchDetected,
tblAssetGroups.AssetGroup
From tblAssets
Inner Join tblQuickFixEngineering On tblAssets.AssetID =
tblQuickFixEngineering.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineeringUni.QFEID =
tblQuickFixEngineering.QFEID
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssetCustom.State = 1
Group By tsysOS.Image,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen
Order By LastPatchDetected