Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 5 subscribers
  • Views 5940 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

Sophos SafeGuard 5.5 POA/Challenge Response Report

HHSMITH

Greetings. We are using Sophos SafeGuard 5.5. Under Policy Items, Power On Authentication, we have the policy "Access denied if no connection to server in 60 days" my question is, is there a report that will tell me when a computer last checked into the server. I looked at the inventory tab and the column Last Policy Received, but the last policy received date doesn't seem to indicate that the computer "checked in" otherwise, I would have a lot of computers sitting in challenge response. We have some computers that don't get used very often and I'm trying to find them before they get locked out with the challenge response. Any help would be appreciated.

:38209


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

    Hi HHSMith,

    the feature you are looking for was introduced in SafeGuard Enterprise 5.60 and is unfortunately not availabel in 5.50.x.

    Should you consider upgrading to version 5.60.x or newer, you can either find a "Last Server Contact" field in the SafeGuard Enterprise Management Center under the inventory of the client machine (or of the domain node, to see the last server contact for all clients in the domain) or query the SafeGuard Database using the following SQL command to retrieve a list of all clients in the SafeGuard Database and their "Last Server Contact" information:

    use SafeGuard

SELECT 
SAFE_GUARD_DIR.SGD_name 'Machine name', 
IVT_INST_FEATURES.IIF_FEATURE 'Feature Installed', 
IVT_INST_FEATURES.IIF_FEATURE_VERSION 'Version', 
convert (VARCHAR,IVT_MACHINES.IMA_LAST_SYNCHRONIZATION, 3 & 8) 'Last Server contact' 

FROM IVT_INST_FEATURES 
INNER JOIN SAFE_GUARD_DIR ON IVT_INST_FEATURES.IIF_MACHINE_ID = SAFE_GUARD_DIR.SGD_ID 
JOIN IVT_MACHINES on SAFE_GUARD_DIR.SGD_ID = IVT_MACHINES.IMA_MACHINE_ID
order by IVT_MACHINES.IMA_LAST_SYNCHRONIZATION asc

    Cheers,
    Chris

    :38289
Reply
  • 0

    Hi HHSMith,

    the feature you are looking for was introduced in SafeGuard Enterprise 5.60 and is unfortunately not availabel in 5.50.x.

    Should you consider upgrading to version 5.60.x or newer, you can either find a "Last Server Contact" field in the SafeGuard Enterprise Management Center under the inventory of the client machine (or of the domain node, to see the last server contact for all clients in the domain) or query the SafeGuard Database using the following SQL command to retrieve a list of all clients in the SafeGuard Database and their "Last Server Contact" information:

    use SafeGuard

SELECT 
SAFE_GUARD_DIR.SGD_name 'Machine name', 
IVT_INST_FEATURES.IIF_FEATURE 'Feature Installed', 
IVT_INST_FEATURES.IIF_FEATURE_VERSION 'Version', 
convert (VARCHAR,IVT_MACHINES.IMA_LAST_SYNCHRONIZATION, 3 & 8) 'Last Server contact' 

FROM IVT_INST_FEATURES 
INNER JOIN SAFE_GUARD_DIR ON IVT_INST_FEATURES.IIF_MACHINE_ID = SAFE_GUARD_DIR.SGD_ID 
JOIN IVT_MACHINES on SAFE_GUARD_DIR.SGD_ID = IVT_MACHINES.IMA_MACHINE_ID
order by IVT_MACHINES.IMA_LAST_SYNCHRONIZATION asc

    Cheers,
    Chris

    :38289
Children
No Data
Unfiltered HTML