Here is where I am stumped, we have a tool that we have ran for about a year now that worked just fine. It queries those views. We can't figure out how it worked. It is just the strangest thing.
Thanks, Monica Readenour CITS E-Mail: [email protected]<mailto:[email protected]> (573) 522-1174 From: [email protected] [mailto:[email protected]] On Behalf Of Eswar Koneti Sent: Tuesday, December 31, 2013 12:19 AM To: [email protected] Subject: RE: [mssms] Views missing in SCCM 2012 SP1 Importance: High I dont see them neither in CM12 SP1 nor CM12 R2.I think they are replaced with vSMS_Boundary,v_BoundarySiteSystems. If you are looking for information about boundaries/boundary groups,you can try the below report: select SUBSTRING(BS.SiteSystemName, 1, CHARINDEX('.', BS.SiteSystemName) -1 ) AS [Site Server], B.Value [Boundary],B.DisplayName [Boundary Discription],b.CreatedBy,b.CreatedOn,b.ModifiedBy,b.ModifiedOn, case b.boundarytype when '3' then 'IP Range' when '1' then 'AD Site' when '0' then 'IP Subnet' when '2' then 'IPV6' else 'None' End as 'Type' from vSMS_Boundary B,v_BoundarySiteSystems BS where b.BoundaryID=bs.BoundaryID order by bs.SiteSystemName Via http://eskonr.com/2013/12/sccm-2012-ssrs-report-site-servers-and-its-assigned-boundary-information/ ------------------------------------ Eswar Koneti Configmgr Consultant www.eskonr.com<http://www.eskonr.com> ------------------------------------ ________________________________ From: [email protected] To: [email protected] Date: Mon, 30 Dec 2013 15:53:51 -0600 Subject: [mssms] Views missing in SCCM 2012 SP1 We are missing three of our views. We don't know when they went away or why. Has anyone else see this? Can someone provide me with the view definition so I can try to recreate then? Should I recreate them or should I go straight to support for help with this one. dbo.v_SiteRoamingBoundary_IPSubnet dbo.v_SiteBoundary_IPSubnet dbo.v_SiteRoamingBoundary_IPRange Thanks, Monica Readenour CITS E-Mail: [email protected]<mailto:[email protected]> (573) 522-1174
