This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SQL Query Management Center for Client version

I am looking at a way to run a report to find the current client version on each machine.  I used the KB below as a reference.  It does not show how to pull the client version though.

 

https://community.sophos.com/kb/en-us/109925

 

I need this as a way to confirm the latest security patch has been applied to all machines.

 

Thanks,



This thread was automatically locked due to age.
Parents
  • The below will return the version for all machines with module "DeviceEncrytion" installed. 

    Can update that to "NextGenDP" for non encrypted drives but Synchronized installed.  (ie where IIF_FEATURE = 'NextGenDP')

     

    Assumes the DB name is SafeGuard

     

    use SafeGuard
    SELECT [SGD_NAME],
    [MAS_SDG_ID],
    [IMA_LAST_SYNCHRONIZATION],
    [IMA_LAST_POLICY_RECEIVED],
    [IMA_ENCRYPTED_DRIVES],
    [IMA_UNENCRYPTED_DRIVES],
    [IIF_FEATURE],
    [IIF_FEATURE_VERSION]

    FROM [SafeGuard].[dbo].[MACHINES]

    inner join IVT_MACHINES on IVT_MACHINES.IMA_MACHINE_ID = MACHINES.MAS_SDG_ID
    inner join IVT_INST_FEATURES on IVT_INST_FEATURES.IIF_MACHINE_ID = MACHINES.MAS_SDG_ID
    inner join SAFE_GUARD_DIR on IVT_INST_FEATURES.IIF_MACHINE_ID = SAFE_GUARD_DIR.SGD_ID

    where IIF_FEATURE = 'DeviceEncryption'


    order by SGD_NAME

Reply
  • The below will return the version for all machines with module "DeviceEncrytion" installed. 

    Can update that to "NextGenDP" for non encrypted drives but Synchronized installed.  (ie where IIF_FEATURE = 'NextGenDP')

     

    Assumes the DB name is SafeGuard

     

    use SafeGuard
    SELECT [SGD_NAME],
    [MAS_SDG_ID],
    [IMA_LAST_SYNCHRONIZATION],
    [IMA_LAST_POLICY_RECEIVED],
    [IMA_ENCRYPTED_DRIVES],
    [IMA_UNENCRYPTED_DRIVES],
    [IIF_FEATURE],
    [IIF_FEATURE_VERSION]

    FROM [SafeGuard].[dbo].[MACHINES]

    inner join IVT_MACHINES on IVT_MACHINES.IMA_MACHINE_ID = MACHINES.MAS_SDG_ID
    inner join IVT_INST_FEATURES on IVT_INST_FEATURES.IIF_MACHINE_ID = MACHINES.MAS_SDG_ID
    inner join SAFE_GUARD_DIR on IVT_INST_FEATURES.IIF_MACHINE_ID = SAFE_GUARD_DIR.SGD_ID

    where IIF_FEATURE = 'DeviceEncryption'


    order by SGD_NAME

Children
No Data