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.
Regards, Eswar Koneti www.eskonr.com On Sep 22, 2016, 4:15 PM, at 4:15 PM, "Miriyala, Vasu" <vasu.miriy...@capgemini.com> wrote: ><Resending for help>… even if one query is answered, rest I can make it >around ☺ > >Hi Champs, > >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 >perspective > >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.