Systems Management Question
Is it possible to have a smart label that looks for computers running a certain Process?
In the computers we manage we have some that are masters and some that are slaves. The computers that are masters (~1/4 of the computeres) are running a process called ProcessA.exe. The slave computers are not running ProcessA.exe. I would like to have a smart label that groups only computers that have ProcessA.exe listed in their Running Processes.
There are some other things that differentiate our master computers from the slave computers but the most reliable indicator that a computer is a Master is whether or not ProcessA.exe is running.
In the future I would like to use all the computers in the Master Label as replication shares for all the computers in the slave label to pull from.
Is there a way for me to create a smart label with all computers that have ProcessA.exe listed in the 'Running Processes' field in the machine's inventory?
Community Chosen Answer
It should be possible. Whenever I've ran queries against processes they tend to go extremely slow, or even lock up the Kbox. I would assume the same would be true in a smart label. Maybe that's why they don't make it available? Either way create a dummy label. Go into the label details and edit the SQL query. This should work for you.
select *, UNIX_TIMESTAMP(now()) - UNIX_TIMESTAMP(LAST_SYNC) as LAST_SYNC_TIME, UNIX_TIMESTAMP(MACHINE.LAST_SYNC) as LAST_SYNC_SECONDS from ORG1.MACHINE LEFT JOIN KBSYS.KUID_ORGANIZATION ON KUID_ORGANIZATION.KUID=MACHINE.KUID LEFT JOIN KBSYS.SMMP_CONNECTION ON SMMP_CONNECTION.KUID = MACHINE.KUID AND KUID_ORGANIZATION.ORGANIZATION_ID = 1 where (( (1 in (select 1 from ORG1.PROCESS, ORG1.MACHINE_PROCESS_JT where MACHINE.ID = MACHINE_PROCESS_JT.MACHINE_ID and MACHINE_PROCESS_JT.PROCESS_ID = PROCESS.ID and PROCESS.NAME like 'PROCESSA.EXE%')) ))