Thanks Sherry that should help us out. Thanks, Monica Readenour CITS E-Mail: [email protected]<mailto:[email protected]> (573) 522-1174
From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, December 30, 2013 6:13 PM To: [email protected] Subject: Re: [mssms] RE: Views missing in SCCM 2012 SP1 Well, I don't have them in CM12 either. In our CM07 site, this is what the views are: v_SiteRoamingBoundary_IPSubnet select SiteCode, IPSubnet, DownloadExecute, DisplayName from dbo.RoamingBoundaryIPSubnet v_SiteBoundary_IPSubnet select SiteCode, IPSubnet from dbo.SiteBoundaryIPSubnet v_SiteRoamingBoundary_IPRange select SiteCode, StartingIP, EndingIP, DownloadExecute, DisplayName from dbo.RoamingBoundaryIPRange Note, I do NOT have any tables called dbo.RoamingBoundaryIPRange, nor SiteBoundaryIPSubnet, nor RoamingBoundaryIPSubnet in CM12… so the view definitions from CM07 likely aren’t as useful as you think they may be. I think what you’ll want to look at is what’s inside dbo.BoundaryEx select * from boundaryEx I’m not sure what you were doing/had done where those views existed for you; but at least for 3 environments now… they don’t exist (in CM12). From: Readenour, Monica<mailto:[email protected]> Sent: Monday, December 30, 2013 5:02 PM To: [email protected]<mailto:[email protected]> Not 100% but we were using them last week and they worked. I wonder if someone from Microsoft could confirm that for us? Thanks, Monica Readenour CITS E-Mail: [email protected]<mailto:[email protected]> (573) 522-1174 From: [email protected] [mailto:[email protected]] On Behalf Of Daniel Ratliff Sent: Monday, December 30, 2013 3:58 PM To: [email protected] Subject: [mssms] RE: Views missing in SCCM 2012 SP1 Are you sure these are 2012 views? We don’t have them either, 2012 SP1 CU3. [cid:[email protected]] Daniel Ratliff From: [email protected] [mailto:[email protected]] On Behalf Of Readenour, Monica Sent: Monday, December 30, 2013 4:54 PM To: '[email protected]' Subject: [mssms] Views missing in SCCM 2012 SP1 Importance: High 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 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.
<<inline: image001.jpg>>
