→ 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: 
Lance
Engaged Sweeper
Hi,

I have this report but I want to add assettype, firstname of user, last name of user after AssetID. Can you assist? Also, is there field that I can add which version of MS Office it's running? If so, can you add it after OSname? Below is report that I have now.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As Icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssetCustom.Model,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblAssets.Username,
tblAssetCustom.Serialnumber,
tsysIPLocations.IPLocation,
tblAssetCustom.Warrantydate
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Order By tblAssets.AssetName
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Please use the report below:


Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As Icon,
tblAssets.AssetID,
tblADusers.Firstname,
tblADusers.Lastname,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssetCustom.Model,
tblAssets.Domain,
tsysOS.OSname,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblAssets.Description,
tblAssets.Username,
tblAssetCustom.Serialnumber,
tsysIPLocations.IPLocation,
tblAssetCustom.Warrantydate
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Microsoft Office%'
Order By tblAssets.AssetName

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
Please use the report below:


Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As Icon,
tblAssets.AssetID,
tblADusers.Firstname,
tblADusers.Lastname,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssetCustom.Model,
tblAssets.Domain,
tsysOS.OSname,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblAssets.Description,
tblAssets.Username,
tblAssetCustom.Serialnumber,
tsysIPLocations.IPLocation,
tblAssetCustom.Warrantydate
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tblAssets.IPNumeric >= tsysIPLocations.StartIP
And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Inner Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftwareUni.softwareName Like '%Microsoft Office%'
Order By tblAssets.AssetName