San Francisco Bay Area Endpoint Management User Group

 View Only

Software inventory blocked by PC Anywhere

  • 1.  Software inventory blocked by PC Anywhere

    Posted Jul 27, 2011 02:47 PM

    during verification of current process noticed that only 550 machines with MS office even though 765 machines had inventory within 30 days

    all polices collect, collect delta software is weekly, full inventory is twice a month.

    we should be good to go


    created filter to show machines that have the Software management framework agent but have not collected add remove software

    based on the following query

    SELECT top 20


    FROM vComputer vc
    WHERE     vc.[Guid] IN
                          (select   ac._resourceguid
    from dbo.Inv_AeX_AC_Client_Agent agent
    left join [Inv_AeX_AC_Identification] ac
    on ac._resourceguid =agent._resourceguid

    where [Agent Name]='Software Management Framework Agent'
    and ac.[client date] > getdate ()-30
    and ac._resourceguid not in (select distinct _resourceguid
    from dbo.Inv_AddRemoveProgram
    where displayname ='Microsoft Office Proof (English) 2007'))
                          AND LOWER(vc.[System Type]) like '%win%'
                          AND vc.[IsManaged] = 1


    created a new inventory policy to test and see what would happen if take the top machines and do a software inventory 

    saved off everything and ran 


    then I get the following in the  error logs

    the specified machine does not have valid pcA License

    I have 800 PCA license with 0 used.


    anybody else? the following article seems to speak to this

    Article URL