Notification

Icon
Error

System Audit - I wanted to create a report that would give me RAM, CPU, BIOS, OS, Warranty end date...

Posted: Wednesday, December 5, 2018 4:22:56 PM(UTC)
miek_g

miek_g

Member Original PosterPosts: 9
0
Like
Select Top 1000000 tsysOS.Image As icon,
tblAssetCustom.AssetID,
tblAssets.AssetName,
tblAssets.Processor,
tblAssets.Memory,
tblBIOS.SMBIOSBIOSVersion,
tsysOS.OSname As OS,
tblAssets.SP As SP,
tblAssetCustom.Warrantydate As [Warranty Expiration],
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblSerialnumber.Product,
tblSerialnumber.productkey
From tblAssetCustom
Inner Join tblAssets On tblAssetCustom.AssetID = tblAssets.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Inner Join tblSerialnumber On tblAssets.AssetID = tblSerialnumber.AssetID
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Where (tblAssets.Memory > 512 And tblAssetCustom.State = 1) Or
(tblAssetCustom.Warrantydate Is Not Null And tblAssetCustom.State = 1)
Order By tblAssets.AssetName

Active Discussions

Lansweeper Trigger deploy when seen
by  bbazian   Go to last post Go to first unread
Last post: Today at 10:31:44 AM(UTC)
Lansweeper More customizable interface
by  Christophe Rahier  
Go to last post Go to first unread
Last post: Today at 9:09:33 AM(UTC)
Lansweeper Update DNS record
by  CyberCitizen   Go to last post Go to first unread
Last post: Today at 1:42:51 AM(UTC)
Lansweeper TeamViewer Custom Action
by  CyberCitizen  
Go to last post Go to first unread
Last post: Today at 1:39:48 AM(UTC)
Lansweeper Deployment Java
by  mlachance   Go to last post Go to first unread
Last post: Yesterday at 4:46:38 PM(UTC)
Lansweeper Custom OID Scanning Range
by  tcooper  
Go to last post Go to first unread
Last post: Yesterday at 4:32:59 PM(UTC)
Lansweeper Approved Software
by  AZHockeyNut   Go to last post Go to first unread
Last post: Yesterday at 4:07:58 PM(UTC)
Lansweeper Scanning targets - ignore assets with LSagent
by  AZHockeyNut  
Go to last post Go to first unread
Last post: Yesterday at 4:01:44 PM(UTC)