Report to Show PC's active in last 30 days as well as software installed on them

[pnorthcott]

Hi

I am new to this tool and a would like to know if someone could create a report that

a) Shows only active computers in the last 30 days

b) Also shows the software installed on each of them (office is what I am after)

I found this that seem to do part a but not sure how to add the software column part b

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssets.Lastseen > GetDate() - 30 And tblState.Statename = 'Active' And
tsysAssetTypes.AssetTypename Like 'Windows%'
Order By tblAssets.Domain,
tblAssets.AssetName

Regards,

Paul

[FrankSc]

Dear,

Using the report editor, you can drag the tables tblsoftware and tblsoftwareuni to the query.
The joins will be automatically made to the existing tables.
Then, you can select the columns you want to see in the report. In the criteria, you can set  = 'yoursoftware' for the software you want to report on.