Notification

Icon
Error

Report to show uptime IF a specific software is installed

Posted: Friday, May 19, 2017 11:06:12 PM(UTC)
trdmc

trdmc

Member Posts: 1
0
Like
I found a report to show uptime of all assets, however I want to limit that report to show uptimes of assets that have a specific software installed.

The uptime report I'm using is below. What do I need to add to limit by software?

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 /
24))) + ' days ' +
Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 %
24))) + ' hours ' +
Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) % 3600 /
60))) + ' minutes' As Uptime
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1 And tblAssets.Uptime Is Not Null
Order By tblAssets.Uptime Desc

Active Discussions

Lansweeper View installed vs available memory
by  prenckens   Go to last post Go to first unread
Last post: Yesterday at 9:11:05 PM(UTC)
Lansweeper static grouping assets by deparment
by  eis-sps-support@buffalo.edu   Go to last post Go to first unread
Last post: Yesterday at 6:41:27 PM(UTC)
Lansweeper Ping by IP, not Netbios
by  MrVal  
Go to last post Go to first unread
Last post: Yesterday at 6:09:00 PM(UTC)
Lansweeper Emails to Agents when Tickets Assigned
by  dpoll7428   Go to last post Go to first unread
Last post: Yesterday at 5:23:32 PM(UTC)
Lansweeper Some users unable to submit tickets
by  wxfisch  
Go to last post Go to first unread
Last post: Yesterday at 5:09:00 PM(UTC)
Lansweeper Kanban Print-out of tickets
by  gkloimstein   Go to last post Go to first unread
Last post: Yesterday at 4:40:13 PM(UTC)
Lansweeper Not working - Computer: No daylight saving time enabled
by  JesseS  
Go to last post Go to first unread
Last post: Yesterday at 4:25:45 PM(UTC)