→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kenm
Engaged Sweeper
I'm trying to make a report that only shows older bios's by date.

How do I set the criteria in the report?

Like this?
< 01/01/2013

1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Hi,

Use the report down here for the information you're after:

Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblBIOS.Caption,
tblBIOS.ReleaseDate
From tblAssets
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Where tblBIOS.ReleaseDate < '2013-01-01'

To use the report above, do the following:
• Open the report builder under Reports/Create New Report.
• Paste the SQL code we provided at the bottom of the page.
• Left-click somewhere in the upper section of the page so the code applies.
• Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.

View solution in original post

2 REPLIES 2
kenm
Engaged Sweeper
That worked. Thanks!
Hemoco
Lansweeper Alumni
Hi,

Use the report down here for the information you're after:

Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblBIOS.Caption,
tblBIOS.ReleaseDate
From tblAssets
Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Where tblBIOS.ReleaseDate < '2013-01-01'

To use the report above, do the following:
• Open the report builder under Reports/Create New Report.
• Paste the SQL code we provided at the bottom of the page.
• Left-click somewhere in the upper section of the page so the code applies.
• Give the report a Title and hit the Save & Run button to save it. Export options are listed on the left.