Notification

Icon
Error

Chart: Computer Bios Age - Años del bios

Posted: Thursday, August 8, 2019 8:05:18 PM(UTC)
Martind

Martind

Member Original PosterPosts: 11
0
Like
Buenos dias

Quisiera saber con que reporte realizan el grafico de Chart: Computer Bios AgeDelete ? quiseira poder seleccionar las PC que estan tomando como base.

gracias
RC62N
#1RC62N Member Posts: 361  
posted: 8/8/2019 8:55:26 PM(UTC)
Code:
Select Top 1000000
  DatePart(yyyy, tblBIOS.ReleaseDate) As Biosyear,
  Count(tblAssets.AssetID) As Total
From
  tblAssets
  Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where
  tblAssetCustom.State = 1
Group By
  DatePart(yyyy, tblBIOS.ReleaseDate)
Order By
  Biosyear

Select from all assets (tblAssets)
For all active assets (tblAssetCustom.State = 1)
Select the year from BIOS release date for each asset (tblBIOS.ReleaseDate)
Count the number of each year
Sort the results by year

tblBIOS is filled with data retrieved from Windows, so no non-Windows computers will have any BIOS data in there, nor will any other assets such as monitors and printers. By doing an INNER JOIN against tblBIOS, then, the results are automatically filtered for only Windows assets, so you don't need to explicitly filter for asset type "Windows".

Active Discussions

Lansweeper Email attachments
by  krejar   Go to last post Go to first unread
Last post: 8/15/2019 10:15:07 PM(UTC)
Lansweeper HP Printer not showing correctly
by  Fathom  
Go to last post Go to first unread
Last post: 8/15/2019 4:14:55 PM(UTC)
Lansweeper Install LsAgent on Mac
by  Jonnym   Go to last post Go to first unread
Last post: 8/14/2019 10:14:08 AM(UTC)
Lansweeper Asset State Question
by  rtaylor  
Go to last post Go to first unread
Last post: 8/13/2019 5:53:24 PM(UTC)
Lansweeper LSAgent Version
by  roberto.m  
Go to last post Go to first unread
Last post: 8/13/2019 3:33:50 PM(UTC)
Lansweeper Lansweeper and snmp v3
by  Justin5135   Go to last post Go to first unread
Last post: 8/12/2019 7:07:22 PM(UTC)
Lansweeper Hikvision CCTV Cameras SNMP scan
by  thejduk  
Go to last post Go to first unread
Last post: 8/12/2019 2:34:05 PM(UTC)