→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
isanchez
Engaged Sweeper
Dear Team

We need a new report group by AD Description and then by assets + software installed.


Example:


AD Description : sales

pc1
software installed

pc2
software installed

pc3
software installed

pc4

AD Description : IT
---
---
---
pc's+software installed






Many Thanks
1 REPLY 1
Hemoco
Lansweeper Alumni
You can use the following report:

Select Top 1000000 tblADComputers.Description,
tblAssets.AssetID,
tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Order By tblADComputers.Description,
tblAssets.AssetName,
tblSoftwareUni.softwareName


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.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now