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 Report for Microsoft Win 7 Extended Support
by  RC62N   Go to last post Go to first unread
Last post: Yesterday at 6:46:53 PM(UTC)
Lansweeper How to make a colour coded report
by  B.Rutherford  
Go to last post Go to first unread
Last post: Yesterday at 4:27:06 PM(UTC)
Report Center All switches and the assets connected to them
by  NWSF   Go to last post Go to first unread
Last post: 12/12/2019 5:23:34 PM(UTC)
Lansweeper Report showing single asset type
by  RC62N  
Go to last post Go to first unread
Last post: 12/11/2019 10:02:41 PM(UTC)
Report Center .Net 4.5 through 4.8 report - Reg Key scanning based
by  Martin Schulz   Go to last post Go to first unread
Last post: 12/11/2019 11:55:24 AM(UTC)
Lansweeper Assets and Owner listing help
by  ssmarr5  
Go to last post Go to first unread
Last post: 12/10/2019 9:23:09 PM(UTC)
Lansweeper HPE SAS Solid State Drives failure report
by  Tommy75   Go to last post Go to first unread
Last post: 12/10/2019 8:04:05 AM(UTC)
Lansweeper Adding Owner/User information to Assets:All column report
by  ssmarr5  
Go to last post Go to first unread
Last post: 12/10/2019 12:15:01 AM(UTC)