Notification

Icon
Error

When was the last launch of the Office programs

Posted: Thursday, October 31, 2019 4:04:52 PM(UTC)
AlexRus227

AlexRus227

Member Original PosterPosts: 10
0
Like
Hello. It is possible to create a report for all PCs. When was the last time Word or Excel was launched?
AlexRus227
#1AlexRus227 Member Original PosterPosts: 10  
posted: 11/1/2019 8:59:34 AM(UTC)
EventID start office 300

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblADusers.Firstname,
tblADusers.Lastname,
tblADusers.Info,
tblADusers.email,
tblADusers.Department,
tblADusers.Title
From tblAssets
Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
Left Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Where tblAssetCustom.State = 1 And Exists(Select tblNtlog.AssetID,
tblNtlog.Eventcode From tblNtlog
Where tblNtlog.AssetID = tblAssets.AssetID And tblNtlog.Eventcode = '300'
And tblNtlog.TimeGenerated >= DateAdd(dd, -90, GetDate()))
Order By tblAssets.AssetName

Active Discussions

Lansweeper "add cc user" doesn't show the correct listings
by  JLPingree   Go to last post Go to first unread
Last post: Yesterday at 8:12:44 PM(UTC)
Lansweeper Default User Date Format
by  RickW99456  
Go to last post Go to first unread
Last post: Yesterday at 5:00:51 PM(UTC)
Lansweeper Duplicate assets (Servers)
by  FrankSc   Go to last post Go to first unread
Last post: Yesterday at 3:20:28 PM(UTC)
Lansweeper Lansweeper load the disk subsystem
by  Alexey Gorbachev  
Go to last post Go to first unread
Last post: Yesterday at 3:13:17 PM(UTC)
Lansweeper Lost Configuration tab (Admin rights)
by  kspap   Go to last post Go to first unread
Last post: Yesterday at 10:30:12 AM(UTC)
Lansweeper Deployment with different user rights
by  Jupiter_IT  
Go to last post Go to first unread
Last post: Yesterday at 9:39:20 AM(UTC)
Lansweeper cisco fuji device not linking with connected devices
by  char   Go to last post Go to first unread
Last post: 7/5/2020 9:12:07 AM(UTC)
Lansweeper Microsoft CVE-2020-1425
by  Richard_B  
Go to last post Go to first unread
Last post: 7/3/2020 4:29:41 PM(UTC)