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: 10
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 check if process is running report
by  Randomusername   Go to last post Go to first unread
Last post: Yesterday at 8:00:49 PM(UTC)
Lansweeper Active Assets Versus Non-Active
by  RC62N  
Go to last post Go to first unread
Last post: Yesterday at 4:57:18 PM(UTC)
Lansweeper Top 10 users submitting tickets
by  ChuckSchurman   Go to last post Go to first unread
Last post: Yesterday at 3:53:21 AM(UTC)
Lansweeper Identifying weak protocols
by  Jason Tree  
Go to last post Go to first unread
Last post: 8/20/2019 3:06:03 PM(UTC)
Lansweeper Ticket Report Overview
by  briangmiller   Go to last post Go to first unread
Last post: 8/20/2019 1:49:35 PM(UTC)
Lansweeper switch ports with multiple assets
by  FischbachM  
Go to last post Go to first unread
Last post: 8/19/2019 9:10:42 AM(UTC)
Lansweeper Modify "....less than 1GB free HD..." Report
by  Cripple.Zero   Go to last post Go to first unread
Last post: 8/15/2019 7:11:10 PM(UTC)
Lansweeper Individual asset compliance
by  ToeCutter  
Go to last post Go to first unread
Last post: 8/15/2019 11:40:57 AM(UTC)