→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Notonyourradar
Engaged Sweeper III
I am not very good at reporting, with that out of the way, I have multiple domains and am looking at how to focus the reports to only report on a specific domain. This is the query I'm using now:

Select Top 1000000 tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
Count(tblSoftware.SoftwareID) As Total
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblSoftwareUni.SoftwarePublisher Like N'%Adobe%' And
tblAssetCustom.State = 1
Group By tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
Order By Total Desc,
Software


I'm looking to get a count of Adobe Products by domain, any help would be much appreciated!
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Do the following:
- In the visual representation of the report in the upper section of the report builder, tick the Domain field in tblAssets to add it to your report.
- In the expression list, tick the Grouping checkbox for the tblAssets.Domain expression.
- Select For Groups in the Criteria For column for the same expression.
- Hit the Save & Run button.

View solution in original post

3 REPLIES 3
Notonyourradar
Engaged Sweeper III
Never mind, I figured it out. Thanks again!
Notonyourradar
Engaged Sweeper III
Thanks! That accomplished what I needed.

Unfortunately I tried to apply this to the OS: Operating System Overview report and have failed ever so miserably. The goal of the report is to report of the count of each OS (2003 standard, enterprise, 2008 std and ent, etc) per domain. If it's not too much to ask could you point me in the right direction?

This is only giving me count by OSname and what I'm really looking for is to get the count by Caption (I guess?)

Select Top 1000000 tblAssets.Domain,
tsysOS.OSname,
Count(tblOperatingsystem.Caption) As Total
From tblAssets
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1
Group By tblAssets.Domain,
tsysOS.OSname
Order By Total Desc,
tsysOS.

Hemoco
Lansweeper Alumni
Do the following:
- In the visual representation of the report in the upper section of the report builder, tick the Domain field in tblAssets to add it to your report.
- In the expression list, tick the Grouping checkbox for the tblAssets.Domain expression.
- Select For Groups in the Criteria For column for the same expression.
- Hit the Save & Run button.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now