As mentioned though, this could be indicative of a larger issue. There is never a normal reason for a view to just disappear. Either there was some anomaly in SQL that caused is to get dropped or you have a "rogue" admin who did something very bad. Either way, not a good thing.
J From: [email protected] [mailto:[email protected]] On Behalf Of Schultz, Michael A Sent: Friday, November 13, 2015 10:51 AM To: [email protected] Subject: [mssms] RE: missing v_R_system This is what we need to do to fix it. 1) Script the view from a good SCCM site (MS PFE's lab) to a create to file 2) Run that query on our site's SQL 3) Then our DBA had to "modify" the fn_rbac_R_system function to reset its metadata Michael Schultz Client Systems Engineering Information Systems Providence Health & Services [email protected]<mailto:[email protected]> From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Jason Sandys Sent: Thursday, November 12, 2015 1:26 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: missing v_R_system V_R_System is more than just AD Discovery. I hope that kicking it off recreates it for you but I doubt it. You really need to reach out to Microsoft CSS ASAP on this as this could be indicative of other issues. J From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Schultz, Michael A Sent: Thursday, November 12, 2015 11:24 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: missing v_R_system They are still on. I think I will try kicking off an AD system scan to see if the view comes back. [cid:[email protected]] Michael Schultz Client Systems Engineering Information Systems Providence Health & Services [email protected]<mailto:[email protected]> From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Jimmy Martin Sent: Thursday, November 12, 2015 9:19 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: missing v_R_system ADDiscovery got turned off? Jimmy Martin (901) 227-8209 From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Schultz, Michael A Sent: Thursday, November 12, 2015 11:17 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] missing v_R_system I have an interesting one. I got a call saying some reports were not working. Looking at the queries, they couldn't find v_R_system. I look at the database and the v_R_system view is gone. Anyone know how to restore or recreate it? Michael Schultz Client Systems Engineering Information Systems Providence Health & Services [email protected]<mailto:[email protected]> ________________________________ This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. This message and any files transmitted with it may contain legally privileged, confidential, or proprietary information. If you are not the intended recipient of this message, you are not permitted to use, copy, or forward it, in whole or in part without the express consent of the sender. Please notify the sender of the error by reply email, disregard the foregoing messages, and delete it immediately. P Please consider the environment before printing this email... ________________________________ This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message. ________________________________ This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
