5 Replies Latest reply on Sep 19, 2019 5:44 AM by Rajesh Kumar Venkatesan

    BSA: All Jobs on all the Windows Server

    Rajesh Kumar Venkatesan
      Share This:

      Hi,

       

      I am working on a task to get a list of all the Jobs that were executed against any Windows Server in my environment. I did not find any BLCLI command. So, I tried to use the following DB query:

       

      select j.NAME ,d.name from job j

      INNER join JOB_DEVICE jd on j.job_id = jd.Job_id

      inner join DEVICE d on jd.device_id = d.device_id

      where d.OS_VENDOR = 'Microsoft' and d.agent_state_id = '100' and d.device_state_id = '50';

       

      Is this correct? If there are any alternate ways, please let me know. There are more than 350+ Win servers in my env; so checking the ACtivity summary in the BAA console is not a feasible option.

       

      Thank you.