static grouping assets by deparment

[eis-sps-support]

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?

[rwallace75]

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