it is in v content. for apps and here is one for packages and drivers. I will send the content one in a sec, I have to rewrite it.
UPDATE v_Package SET PkgSourcePath = Replace(PkgSourcePath, '\\dfghfgh\osd$\Drivers\Package_Source\Win7\x64\', '\\ushubcm03\osd$\Drivers\Win7\x64') Where PkgSourcePath Like '\\sfghsfghsfg\osd$\Drivers\Package_Source\Win7\x64\%' AND PackageID = 'EXT0020D' On Fri, May 31, 2013 at 10:21 AM, Marcum, John <[email protected]> wrote: > I need anything that has a source, but mainly msi and script based. I > see them in V_Package but the source is not listed there. > > > > Seems like there should be a v_Application but there’s not L > > > > > > > > > > > > > > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Stephen Leuthold > *Sent:* Friday, May 31, 2013 10:17 AM > *To:* [email protected] > *Subject:* RE: [mssms] SQL for Application Source Path > > > > Deployment types? Todd Hemsell had the same question and I answered it a > week or so ago.. Let me see if I can dig it up. > > Sent from my Windows Phone > ------------------------------ > > *From: *Marcum, John <[email protected]> > *Sent: *5/31/2013 9:52 AM > *To: *SMS List ([email protected]) <[email protected]> > *Subject: *[mssms] SQL for Application Source Path > > Does anyone happen to know where in SQL I can find the source path of all > my applications? > > > > > > > > John > > > > > > > > > > > ------------------------------ > > > Confidentiality Notice: This e-mail is from a law firm and may be > protected by the attorney-client or work product privileges. If you have > received this message in error, please notify the sender by replying to > this e-mail and then delete it from your computer. > > > ------------------------------ > > > Confidentiality Notice: This e-mail is from a law firm and may be > protected by the attorney-client or work product privileges. If you have > received this message in error, please notify the sender by replying to > this e-mail and then delete it from your computer. > > ------------------------------ > > Confidentiality Notice: This e-mail is from a law firm and may be > protected by the attorney-client or work product privileges. If you have > received this message in error, please notify the sender by replying to > this e-mail and then delete it from your computer. > >
