For sql query, Applications, packages, task sequence and software updates, each
has its own table/view that store in database. So it require to union the
results that you get from each or other methods if any.
Can check if I find something.
On Sep 22, 2016, 4:15 PM, at 4:15 PM, "Miriyala, Vasu"
><Resending for help>… even if one query is answered, rest I can make it
>Could you be of help sharing
>1) A sql query that helps to find TS, Software, patches etc
>content that is deployed to a client … from server perspective
>2) A WMI query to get similar info as in 1) ….from clients
>Seems I failed to get this from net, other online sourced that I tried…
>Thanks a ton, Vasu
>This message contains information that may be privileged or
>confidential and is the property of the Capgemini Group. It is intended
>only for the person to whom it is addressed. If you are not the
>intended recipient, you are not authorized to read, print, retain,
>copy, disseminate, distribute, or use this message or any part thereof.
>If you receive this message in error, please notify the sender
>immediately and delete all copies of this message.