I want to know how to add a date report in my external USB report .
Also if anyone knows how to set the license key overview report to see the office 2013 key.
Thank you!
My current USB report :
Select Top 1000000 tblAssets.AssetID,
tblAssets.Username,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysOS.OSname As OS,
tsysOS.Image As icon,
tblFloppy.Manufacturer As [Drive Manufacturer],
tblFloppy.Model As [Drive Model],
tblFloppy.Size
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblFloppy On tblAssets.AssetID = tblFloppy.AssetID
Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1 And tblFloppy.InterfaceType = N'USB'
Order By tblAssets.IPAddress
