I ended up dumping it all into excel, doing a bit of work to match the updates to the product name. On 23 Dec 2015 10:14 a.m., "Conrad Jones" <[email protected]> wrote:
> That doesnt give me anything I don't already have > > It has the applicability rule product id as a guid. I want to map this > guid to a product name. > On 22 Dec 2015 5:49 p.m., "Daniel Ratliff" <[email protected]> wrote: > >> Anytime I need update information I look at v_update_info in the DB. >> >> >> >> *Daniel Ratliff* >> >> >> >> *From:* [email protected] [mailto: >> [email protected]] *On Behalf Of *Conrad Jones >> *Sent:* Tuesday, December 22, 2015 12:40 PM >> *To:* [email protected] >> *Subject:* [mssms] Applicabilityrule >> >> >> >> I am looking at pulling a list of updates from the db via power shell. >> >> Does anyone know about the applicability rule specifically the productid >> ? I am trying to match the productid in the rule to a product name. My life >> on either power shell or SQL to do this? Point me in the direction of a >> table or view and I'll be happy. >> >> >> >> The information transmitted is intended only for the person or entity to >> which it is addressed >> and may contain CONFIDENTIAL material. If you receive this >> material/information in error, >> please contact the sender and delete or destroy the material/information. >> >> >
