Client Management Suite

 View Only
  • 1.  What all Policies are using a software as prerequisite..?

    Posted Sep 23, 2015 03:38 AM

    Hello All,

    Is it possible to get what all Policies are using a software as prerequisite in altiris.



  • 2.  RE: What all Policies are using a software as prerequisite..?

    Broadcom Employee
    Posted Sep 23, 2015 11:32 AM

    You mean about this below?

    What agent plug-in you need to install on client PC prior to receive there and manage them by:

    • Symantec Management Agent settings policy
    • Managed Software Delivery policy
    • Patch Update policy
    • Software and hardware inventory scan policy
    • etc

    Thanks,

    IP.

     

     



  • 3.  RE: What all Policies are using a software as prerequisite..?

    Posted Sep 24, 2015 03:30 AM


    Here the Policy what I mean is: To deploy a software(MS Office, Adobe Acrobat, VLC etc)  we will create a Managed Software Delivery Policy with the required settings.

    And part the Managed Software Delivery we can add Pre-requisites if needed.
    Please find the below screen shot for your reference.

    Capture.PNG

    Can we have any SQL query to get a report that What all Policies are using a perticual softwre as Pre-requsits.

     

     



  • 4.  RE: What all Policies are using a software as prerequisite..?
    Best Answer

    Posted Sep 24, 2015 05:25 AM

    Don't know about policies, but here is a query which software depends on ...

    SELECT
    vi2.Name AS [Software],
    vi3.Name AS [Depends on]
    FROM vItem vi1
    JOIN ResourceAssociation ra ON ra.ResourceAssociationTypeGuid = vi1.[Guid]
    JOIN vItem vi2 ON vi2.[Guid] = ra.ParentResourceGuid
    JOIN vItem vi3 ON vi3.[Guid] = ra.ChildResourceGuid
    where ra.ResourceAssociationTypeGuid = '920F1D74-8FCF-4553-9208-4AE2882D4315' -- Software Component Depends on Software Component
    and vi3.classguid ='B6FE92FD-D5AC-4DC2-A023-A56C2973A413' --Software Release
    ORDER BY 2 DESC



  • 5.  RE: What all Policies are using a software as prerequisite..?

    Posted Sep 24, 2015 05:53 AM

    Thanks Mistral..

    It works....!



  • 6.  RE: What all Policies are using a software as prerequisite..?

    Posted Sep 24, 2015 05:56 AM
    When you delete a software resource that a Policy is using you will get a message with a link that gives the list you require. Create two dummy software resources, one dependent on the other, add them to a policy then try and delete the one that is depended on. When you get the error message, run SQL Server profiler before you click the link and you should then be able to find the SQL query used.