→ 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: 
RDizzle
Engaged Sweeper II
Hi

Iam looking for a report to report on the "uptime" of assets I hhave found a standard one as of yet.
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
FYI for everyone: sample reports can also be found in the report center. See this link.

View solution in original post

2 REPLIES 2
Susan_A
Lansweeper Alumni
FYI for everyone: sample reports can also be found in the report center. See this link.
RCorbeil
Honored Sweeper II
The best I've been able to come up with is based on tblAssets.lastseen and uptime. Add a couple of calculated fields to the default query to get you going.
SELECT Top 1000000
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
DateAdd(second, 0 - tblAssets.Uptime, tblAssets.Lastseen) AS LastBoot,
Convert(Decimal(6,2),tblAssets.Uptime / 60 / 60 / 24) AS DaysUp
FROM
tblAssets
INNER JOIN tblAssetCustom ON tblAssets.AssetID = tblAssetCustom.AssetID
INNER JOIN tsysAssetTypes ON tsysAssetTypes.AssetType = tblAssets.Assettype
WHERE
tblAssetCustom.State = 1