Notification

Icon
Error

check if process is running report

Posted: Thursday, August 22, 2019 7:37:51 PM(UTC)
Randomusername

Randomusername

Member Original PosterPosts: 4
0
Like
I couldn't find it anywhere on here.

I need a report that scans one server and checks if a process is not running.

ex.,

ServerA needs explorer.exe to be running in the task manager. The report should populate that ServerA does not have explorer.exe running. If explorer.exe is running, the report should have no result.

Is this something lansweeper is capable of and if yes, can someone assist me with it?

I tried below but it claims assetname is an invalid column.


Select tblAssets.AssetName, tblProcesses.Caption
where tblAssets.AssetName = 'Server' AND tblProcesses.Caption = 'Process.exe'
Randomusername
#1Randomusername Member Original PosterPosts: 4  
posted: 8/22/2019 8:00:49 PM(UTC)
I figured out the issue. I had to select the names from the search box. For whatever reason, it didn't like them typed.


Select Top 1000 tblAssets.AssetName,
tblProcesses.Caption
From tblAssets
Inner Join tblProcesses On tblAssets.AssetID = tblProcesses.AssetID
Where tblAssets.AssetName = 'Server' And tblProcesses.Caption =
'Process.exe'


I need this to follow what I wrote above. To be blank if true and populate if false. This is so I can setup an email alert when it is false.
Randomusername
#2Randomusername Member Original PosterPosts: 4  
posted: 8/23/2019 3:29:16 PM(UTC)
Well, I tried <> and that just shows all processes other than the one I want.

I ended up just saving this report as a chart for now and placing it on the main page.

Hopefully, someone will eventually be able to assist me in making the report do what I need.

Active Discussions

Lansweeper Remove all users from old domain
by  cmuter   Go to last post Go to first unread
Last post: 9/20/2019 8:03:58 PM(UTC)
Lansweeper Static IP Address
by  cycleheat  
Go to last post Go to first unread
Last post: 9/20/2019 4:07:16 PM(UTC)
Lansweeper Bitlocker Encryption Recovery Key no information found
by  Stephane   Go to last post Go to first unread
Last post: 9/20/2019 2:26:19 PM(UTC)
Lansweeper InTune Scanning Issues
by  Esben.D  
Go to last post Go to first unread
Last post: 9/20/2019 12:34:59 PM(UTC)
Lansweeper Office 365 scanning issues
by  Esben.D   Go to last post Go to first unread
Last post: 9/20/2019 12:23:30 PM(UTC)
Lansweeper Hard Drive Tracking - Start to Finish
by  Lone Jedi  
Go to last post Go to first unread
Last post: 9/19/2019 8:11:56 PM(UTC)
Lansweeper Lansweeper Reporting Old Assets as New
by  Jpatterson   Go to last post Go to first unread
Last post: 9/19/2019 12:52:14 PM(UTC)
Lansweeper Cannot edit a ticket anymore
by  Esben.D  
Go to last post Go to first unread
Last post: 9/19/2019 12:32:42 PM(UTC)