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: 396  
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 TPM scanning
by  gene@sca   Go to last post Go to first unread
Last post: Yesterday at 10:40:24 PM(UTC)
Lansweeper Bulk AssetLock set
by  tcooper  
Go to last post Go to first unread
Last post: Yesterday at 6:24:15 PM(UTC)
Lansweeper Set AssetType based on Model?
by  tcooper   Go to last post Go to first unread
Last post: Yesterday at 6:16:57 PM(UTC)
Lansweeper Public IP Address
by  David Goodwin  
Go to last post Go to first unread
Last post: Yesterday at 4:57:14 PM(UTC)
Lansweeper Exchange Scan in v7 and DAG
by  Peter.Riederer   Go to last post Go to first unread
Last post: Yesterday at 8:42:48 AM(UTC)
Lansweeper Asset Scanning - Change Types
by  DNuhija  
Go to last post Go to first unread
Last post: 12/12/2019 5:40:47 PM(UTC)
Lansweeper Plundervolt
by  NWSF   Go to last post Go to first unread
Last post: 12/12/2019 5:10:14 PM(UTC)
Lansweeper MSI Package
by  Stefano Magri  
Go to last post Go to first unread
Last post: 12/12/2019 3:34:16 PM(UTC)