→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
SEC_ALERTS
Engaged Sweeper
Hi Team,

If possible ,We need report for those machine which are not restarted since 7 days.

Regards,
SEC_ALERTS.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
A sample report can be seen below. Note that uptime information won't be accurate unless your machines have recently and successfully been rescanned. You can rescan assets by clicking the Assets link at the top of the web console, ticking the checkboxes in front of the assets and hitting the Rescan button on the left.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
Convert(Decimal(6,2),tblAssets.Uptime / 60 / 60 / 24) As Uptime
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where Convert(Decimal(6,2),tblAssets.Uptime / 60 / 60 / 24) > 7 And
tblAssetCustom.State = 1
Order By tblAssets.IPNumeric

View solution in original post

4 REPLIES 4
Hemoco
Lansweeper Alumni
dstjames wrote:
How would you restrict this to only computers or even better only workstations since I dont need to know when my servers or networking equipment last rebooted?

Do the following:
• Run the report.
• Double-click on tblComputersystem in the table list on the right to add it to your report.
• In the visual representation of the report in the upper section of the report builder, tick the Domainrole field in tblComputersystem to add it to your report.
• Add the below criterion to the Criteria column for the tblComputersystem.Domainrole expression. TblComputersystem data is pulled from the Win32_ComputerSystem WMI (Windows Management Instrumentation) class. The following Microsoft knowledge base article explains what each Domainrole value means: http://msdn.microsoft.com/en-us/library/aa394102%28v=vs.85%29.aspx
<2
dstjames
Engaged Sweeper
How would you restrict this to only computers or even better only workstations since I dont need to know when my servers or networking equipment last rebooted?
SEC_ALERTS
Engaged Sweeper
It Works!!
Thanks a lot !!!
Hemoco
Lansweeper Alumni
A sample report can be seen below. Note that uptime information won't be accurate unless your machines have recently and successfully been rescanned. You can rescan assets by clicking the Assets link at the top of the web console, ticking the checkboxes in front of the assets and hitting the Rescan button on the left.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
Convert(Decimal(6,2),tblAssets.Uptime / 60 / 60 / 24) As Uptime
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where Convert(Decimal(6,2),tblAssets.Uptime / 60 / 60 / 24) > 7 And
tblAssetCustom.State = 1
Order By tblAssets.IPNumeric

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now