Thread Info
  • State Suggested Answer
  • Locked Locked
  • Replies 1 reply
  • Answers 1 answer
  • Subscribers 7 subscribers
  • Views 1932 views
  • Users 0 members are here
Options
Suggested
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

Finding Computers Using Cloud Storage

John Evans

Our Sophos SafeGuard came with 5 demo licenses for "Cloud Storage", "Data Exchange", and "File Encryption." We're using 4 out of the 5, and the demo license expired on December 31st of 2016. We're now 31 days beyond that expiration date and our ability to push policies to our non-demo users has been suspended.

How do I search and find the 4 computers using those three types of demo licenses and get them removed? I can probably figure out the uninstall/delete process, but there is no search (that I can find) of "show me all computers using Cloud Storage."

Any pointers on how to find these computers would be greatly appreciated.

Thanks.



This thread was automatically locked due to age.
Parents
  • 0

    Hi John,

     

    To find these machines you will need to query the SQL database.

    This is taken directly from the following article,  http://sophos.com/kb/109925

    Report 3. A list of all installed features

    This is a general script that can be used for several tasks. Please remove comments in order to receive the required information

    /* Selecting all installed features on all available machines*/

    use SafeGuard
    SELECT
    SAFE_GUARD_DIR.SGD_name as 'Machine name',
    IVT_INST_FEATURES.IIF_FEATURE as 'Feature Installed',
    convert (VARCHAR,IVT_INST_FEATURES.IIF_MODIFY_DATE,3) as 'Last modified'
    FROM IVT_INST_FEATURES INNER JOIN
    SAFE_GUARD_DIR ON IVT_INST_FEATURES.IIF_MACHINE_ID = SAFE_GUARD_DIR.SGD_ID
    order by SAFE_GUARD_DIR.SGD_name

     

     

    Once run, you will have a list of all machines and their installed components. This can be be saved as a .csv file if you wish to manipulate the output.

    To remove the components on the workstations, in programs a features, select the Safeguard Client and "modify".  Remove the components in question and resync. 

    In the management center in the license tab click on recount.   The change will be reflected straight away.

    Bill.

Reply
  • 0

    Hi John,

     

    To find these machines you will need to query the SQL database.

    This is taken directly from the following article,  http://sophos.com/kb/109925

    Report 3. A list of all installed features

    This is a general script that can be used for several tasks. Please remove comments in order to receive the required information

    /* Selecting all installed features on all available machines*/

    use SafeGuard
    SELECT
    SAFE_GUARD_DIR.SGD_name as 'Machine name',
    IVT_INST_FEATURES.IIF_FEATURE as 'Feature Installed',
    convert (VARCHAR,IVT_INST_FEATURES.IIF_MODIFY_DATE,3) as 'Last modified'
    FROM IVT_INST_FEATURES INNER JOIN
    SAFE_GUARD_DIR ON IVT_INST_FEATURES.IIF_MACHINE_ID = SAFE_GUARD_DIR.SGD_ID
    order by SAFE_GUARD_DIR.SGD_name

     

     

    Once run, you will have a list of all machines and their installed components. This can be be saved as a .csv file if you wish to manipulate the output.

    To remove the components on the workstations, in programs a features, select the Safeguard Client and "modify".  Remove the components in question and resync. 

    In the management center in the license tab click on recount.   The change will be reflected straight away.

    Bill.

Children
No Data
Unfiltered HTML