cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
ehorde
Engaged Sweeper II
Hello,

I am trying to build a report that will tell me if a system has a process running or not.

I can write a report that show me if a process is running, and also if a system is missing a process, but I am stumbling on the syntax of writing a report that tells me both states. e.g. - Yes or No.

Example output I am trying to get

Asset Name, Process Name, Process Running?

JoesComputer, SCCM, Running -or- JoesComputer, SCCM, Not Running

tables are tblAssets and tblProcesses


Here's my current non-working train wreck

----------------
Select Top 1000000 tblAssets.AssetUnique,
tblAssets.AssetName,
Case When Where tblAssets.AssetName Not In (Select tblAssets.AssetName From tblProcesses
Where tblProcesses.Caption = 'CCMExec.exe') Then 'No') (When (Where tblAssets.AssetName In (Select tblAssets.AssetName From tblProcesses
Where tblProcesses.Caption = 'CCMExec.exe') Then 'Yes') As [Status],
From tblAssets
Inner Join tblProcesses On tblAssets.AssetID = tblProcesses.AssetID




Thanks much in advance....
0 REPLIES 0