Reporting Group

Can someone provide a report to determine which agents have switched over the HTTPS from HTTP.  We are working on setting up CEM and want to make sure all active machines have switched over before turning HTTP off.  I can't find a good report built in unless I use Analytics.

Thank you,

Misty

What igor provided is good for a filter but I believe you were looking for a report.  I'm not aware of any built-in report but here is a simple report that shows each managed machine and whether it is using HTTPS mode.  It also shows the last time it succesfully used CEM which may be useful as you roll that out.  

select vc.Name, vc.[IP Address], vc.[Domain]
    ,nz.InternetModeSupported,nz.IsOnInternet, nz.httpsmode
    ,cem.gateway, cem.[Last Success], cem.[Current]
from vComputer vc
    left join Inv_AeX_AC_InternetGatewayDetails cem on cem._ResourceGuid = vc.Guid
    left join Inv_AeX_AC_Network_Zone nz ON nz._ResourceGuid = vc.[Guid]
where vc.isManaged = 1

Also, it is not necessary to turn off HTTP.  We are running an enviornment with HTTP and HTTPS enabled and CEM is working great.  

Hi mmathews!

You can clone default "All Computers operating over HTTP" filter and just modify there existing query to include only HTTPs mode computers

---/// Modified query to include computers over HTTPs

SELECT        cr.[Guid]
    FROM      vRM_Computer_Item         cr
    JOIN      ServerSettingGuids        ss ON ss.Name = 'OwnerNSGuid' AND ss.Value = cr.OwnerNSGuid
    LEFT JOIN ResourceAssociation       ra ON ra.ParentResourceGuid = cr.[Guid]
                                          AND ra.ResourceAssociationTypeGuid = '3028166F-C0D6-41D8-9CB7-F64852E0FD01'
    JOIN      Inv_AeX_AC_Client_Agent   ca ON ca._ResourceGuid = cr.[Guid] AND ca.[Agent Name] = N'Altiris Agent'
    JOIN      Inv_AeX_AC_Network_Zone   nz ON nz._ResourceGuid = cr.[Guid]
    WHERE     cr.IsManaged = 1
    AND       cr.ResourceItemDeleted = 0
    AND     ( ra.ChildResourceGuid IS NULL OR ra.ChildResourceGuid = '0A0203A5-D2B6-49f1-A53B-5EC31A89437C' )
    AND       nz.HTTPSMode = 1 
    AND       dbo.fnVersionCompare2( ca.[Product Version], dbo.fnGetComparableVersion('%MinimumAgentVersion%') ) >= 0

Were you able to get this report working?