Home
%3CLINGO-SUB%20id%3D%22lingo-sub-884624%22%20slang%3D%22en-US%22%3EHow%20to%20create%20a%20RBA%20capable%20report%20for%20ConfigMgr%20R2%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-884624%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20TECHNET%20on%20Nov%2028%2C%202013%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3E%3CI%3E%20Authored%20by%20Santos%20Martinez%20%3C%2FI%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EHello%20all%2C%20ConfigNinja%20here%20trying%20to%20show%20you%20a%20few%20tips%20and%20tricks%20to%20convert%20your%20current%20custom%20reports%20using%20the%20new%20RBA(Role%20Based%20Administration)%20for%20reports.%20%3CA%20href%3D%22http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fdn236351.aspx%23BKMK_WhatsNew_Monitoring_and_Reporting%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2Fdn236351.aspx%23BKMK_WhatsNew_Monitoring_and_Reporting%20%3C%2FA%3E%20This%20new%20feature%20on%20R2%20brings%26nbsp%3B%20lots%20of%20benefits%2C%20especially%20for%20those%20users%20that%20don%E2%80%99t%20need%20to%20have%20access%20to%20all%20the%20data%20within%20ConfigMgr%20and%20limit%20what%20you%20allow%20them%20to%20view.%20Read%20more%20about%20this%20here%2C%20%3CA%20href%3D%22http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2F7ca322fc-bbbf-42c8-82c9-6fc8941ef2e6%23BKMK_RoleBaseAdministration.%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Flibrary%2F7ca322fc-bbbf-42c8-82c9-6fc8941ef2e6%23BKMK_RoleBaseAdministration.%20%3C%2FA%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CIMG%20alt%3D%22STB13_Csonger_03%22%20border%3D%220%22%20height%3D%22357%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134586iD58383FC1B9F8B49%22%20title%3D%22STB13_Csonger_03%22%20width%3D%22536%22%20%2F%3E%3C%2FP%3E%0A%20%20%3CH2%20id%3D%22toc-hId-1823871362%22%20id%3D%22toc-hId-1823925955%22%3EModify%20a%20custom%20report%3C%2FH2%3E%0A%20%20%3CP%3EWe%20are%20going%20to%20modify%20your%20custom%20report%20using%20Report%20Builder%2C%20Once%20you%20have%20the%20Report%20Builder%20open%20we%20will%20review%20a%20few%20things%20before%20updating%20your%20new%20custom%20report.%3C%2FP%3E%0A%20%20%3CP%3EFirst%20let%E2%80%99s%20review%20one%20of%20the%20new%20reports%20from%20ConfigMgr%202012%20R2%2C%20at%20your%20SSRS%20Website%20%3CSTRONG%3E%20http%3A%2F%2Fcmsite%2Freports.%20%3C%2FSTRONG%3E%3C%2FP%3E%0A%20%20%3CP%3ENext%2C%20let%E2%80%99s%20go%20to%20Software%20Distribution%20-%20Collections%20%26gt%3B%20All%20resources%20in%20a%20specific%20collection%20click%20on%20the%20drop%20down%20and%20select%20edit%20in%20Report%20Builder.%3C%2FP%3E%0A%20%20%3CP%3ENow%20that%20you%20are%20on%20Report%20Builder%2C%20let%E2%80%99s%20review%20a%20few%20details%20that%20are%20new%20on%20this%20report.%3C%2FP%3E%0A%20%20%3CP%3E%3CIMG%20alt%3D%22clip_image002%22%20border%3D%220%22%20height%3D%22421%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134587iC2861C9BBECB3E3D%22%20title%3D%22clip_image002%22%20width%3D%22190%22%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3EWe%20have%20%3CSTRONG%3E%20UserTokenSIDs%20%3C%2FSTRONG%3E%20and%20%3CSTRONG%3E%20UserSIDS%20%3C%2FSTRONG%3E%20on%20the%20Parameters%20section%3B%20also%20we%20have%20a%20new%20Dataset%20call%20%3CSTRONG%3E%20DataSetAdminID%20%3C%2FSTRONG%3E%20.%3C%2FP%3E%0A%20%20%3CP%3ELet%E2%80%99s%20review%20the%20query%20inside%20the%20%3CSTRONG%3E%20DataSetAdminID%20%3C%2FSTRONG%3E%20%3A%3C%2FP%3E%0A%20%20%3CPRE%3E%3CPRE%3E%E2%80%9C%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Dselect%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eselect%3C%2FA%3E%20dbo.fn_rbac_GetAdminIDsfromUserSIDs%20(%40UserTokenSIDs)%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Das%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eas%3C%2FA%3E%20UserSIDs%E2%80%9D%3C%2FPRE%3E%3C%2FPRE%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20Now%20let%E2%80%99s%20review%20the%202%20prompts%20that%20are%20part%20of%20my%20report.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20%40UserTokenSIDs%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%20general%20Configuration%3A%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20%3CIMG%20alt%3D%22clip_image004%22%20border%3D%220%22%20height%3D%22346%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134588iBC33CFD640EEDA65%22%20title%3D%22clip_image004%22%20width%3D%22419%22%20%2F%3E%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20Available%20Values%20leave%20as%20default%20that%20should%20be%20NONE.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20%3CIMG%20alt%3D%22clip_image006%22%20border%3D%220%22%20height%3D%22353%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134589i7303A994EBF656F1%22%20title%3D%22clip_image006%22%20width%3D%22425%22%20%2F%3E%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20Default%20Values%2C%20Specify%20values.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20The%20value%20will%20be%20an%20expression%2C%20click%20on%20the%20expression%20button%20to%20see%20the%20expression%20code.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CPRE%3E%3CPRE%3E%3DSrsResources.UserIdentity.GetUserSIDs(%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DUser%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EUser%3C%2FA%3E!UserID)%3C%2FPRE%3E%3C%2FPRE%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20Leave%20this%20as%20the%20default.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20Let%E2%80%99s%20review%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20%40UserSIDs%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%20Prompt%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20%3CIMG%20alt%3D%22clip_image008%22%20border%3D%220%22%20height%3D%22352%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134590i7F9A8D39E4DFD00F%22%20title%3D%22clip_image008%22%20width%3D%22426%22%20%2F%3E%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20On%20the%20Available%20Values%20page%2C%20leave%20as%20default%20wich%20should%20be%20NONE%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20Review%20the%20Default%20Values%20page%20and%20other%20pages%20but%20do%20not%20make%20changes.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20%3CIMG%20alt%3D%22clip_image010%22%20border%3D%220%22%20height%3D%22352%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134591i76852248541D78A9%22%20title%3D%22clip_image010%22%20width%3D%22426%22%20%2F%3E%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20Now%20that%20we%20understand%20the%20prompt%20let%E2%80%99s%20review%20the%20main%20Datasets%20of%20this%20reports%20and%20review%20the%20code.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20On%20the%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20DataSet1%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%20%2C%20the%20code%20is%20as%20follow.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CPRE%3E%3CPRE%3E%E2%80%9C%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DSelect%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ESelect%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DDistinct%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EDistinct%3C%2FA%3E%20CollectionID%2C%20Name%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DFROM%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EFROM%3C%2FA%3E%20fn_rbac_collection(%40UserSIDs)%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Dorder%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eorder%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Dby%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eby%3C%2FA%3E%20Name%E2%80%9D%3C%2FPRE%3E%3C%2FPRE%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20This%20T-SQL%20Code%20in%20the%20past%20use%20to%20be%20like%20this%3A%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CPRE%3E%3CPRE%3E%E2%80%9C%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DSelect%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ESelect%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DDistinct%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EDistinct%3C%2FA%3E%20CollectionID%2C%20Name%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DFROM%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EFROM%3C%2FA%3E%20v_Collection%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DOrder%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EOrder%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DBy%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EBy%3C%2FA%3E%20Name%E2%80%9D%3C%2FPRE%3E%3C%2FPRE%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20We%20had%20replaced%20the%20view%20for%20a%20function%2C%20and%20with%20the%20replace%20of%20a%0A%20%20%20%3CFONT%3E%0A%20%20%20%20%3CSTRONG%3E%0A%20%20%20%20%20V_%0A%20%20%20%20%3C%2FSTRONG%3E%0A%20%20%20%3C%2FFONT%3E%0A%20%20%20we%20need%20to%20add%0A%20%20%20%3CFONT%3E%0A%20%20%20%20%3CSTRONG%3E%0A%20%20%20%20%20fn_rbac_%0A%20%20%20%20%3C%2FSTRONG%3E%0A%20%20%20%3C%2FFONT%3E%0A%20%20%20and%20then%20after%20the%20function%20or%20view%20add%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20(%40UserSIDs).%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20Let%E2%80%99s%20take%20a%20look%20at%20the%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20Dataset2%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%20%2C%20here%20is%20the%20query%20inside%20this%20dataset.%0A%20%20%3C%2FP%3E%0A%20%20%3CPRE%3E%3CPRE%3E%E2%80%9C%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DSelect%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ESelect%3C%2FA%3E%20fcm.Name%2C%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DCASE%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ECASE%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DWHEN%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EWHEN%3C%2FA%3E%20coll.CollectionType%3D1%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DTHEN%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ETHEN%3C%2FA%3E%20fcm.SMSID%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DELSE%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EELSE%3C%2FA%3E%20fcm.Name%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DEND%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EEND%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Das%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eas%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DIs%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EIs%3C%2FA%3E%2C%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DCASE%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ECASE%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DWHEN%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EWHEN%3C%2FA%3E%20ResourceType%20%3D%203%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DTHEN%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ETHEN%3C%2FA%3E%20%E2%80%98*%E2%80%99%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DELSE%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EELSE%3C%2FA%3E%20%E2%80%98%E2%80%99%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DEND%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EEND%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Das%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eas%3C%2FA%3E%20C066%2C%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DCASE%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ECASE%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DWHEN%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EWHEN%3C%2FA%3E%20ResourceType%20%3D%204%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DTHEN%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ETHEN%3C%2FA%3E%20%E2%80%98*%E2%80%99%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DELSE%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EELSE%3C%2FA%3E%20%E2%80%98%E2%80%99%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DEND%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EEND%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Das%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eas%3C%2FA%3E%20C067%2C%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DCASE%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ECASE%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DWHEN%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EWHEN%3C%2FA%3E%20ResourceType%20%3D%205%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DTHEN%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ETHEN%3C%2FA%3E%20%E2%80%98*%E2%80%99%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DELSE%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EELSE%3C%2FA%3E%20%E2%80%98%E2%80%99%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DEND%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EEND%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Das%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eas%3C%2FA%3E%20C068%2C%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3ESiteCode%2C%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DCASE%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ECASE%3C%2FA%3E%20IsDirect%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DWhen%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EWhen%3C%2FA%3E%201%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DTHEN%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ETHEN%3C%2FA%3E%20%E2%80%98*%E2%80%99%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DWhen%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EWhen%3C%2FA%3E%200%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DTHEN%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ETHEN%3C%2FA%3E%20%E2%80%98%E2%80%99%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DEND%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EEND%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DAS%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EAS%3C%2FA%3E%20C069%2C%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3EColl.CollectionType%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DFrom%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EFrom%3C%2FA%3E%20fn_rbac_FullCollectionMembership%20(%40UserSIDs)%20fcm%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DINNER%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EINNER%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DJOIN%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EJOIN%3C%2FA%3E%20fn_rbac_collection(%40UserSIDs)%20coll%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Don%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eon%3C%2FA%3E%20fcm.CollectionID%20%3D%20coll.CollectionID%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DWhere%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EWhere%3C%2FA%3E%20fcm.CollectionID%20%3D%20%40ID%E2%80%9D%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3C%2FPRE%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20As%20you%20can%20see%20on%20this%20query%2C%20the%20query%20had%20been%20modified%20to%20first%20validate%20the%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20UserSIDs%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%20before%20displaying%20the%20report%20data.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20Now%20let%E2%80%99s%20convert%20a%20custom%20report%20without%20Role%20Based%20Administration%20into%20using%20RBA.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20For%20this%2C%20I%20will%20modify%20a%20Quick%20Fix%20Engineering%20Report%20that%20was%20created%20without%20RBA.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20%3CIMG%20alt%3D%22clip_image012%22%20border%3D%220%22%20height%3D%22416%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134592iE3D88DB09071BDB7%22%20title%3D%22clip_image012%22%20width%3D%22234%22%20%2F%3E%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20As%20you%20can%20see%20on%20this%20image%2C%20there%20is%20a%20missing%20Prompt%20and%20a%20missing%20data%20set%20from%20this%20report.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20Plus%20let%E2%80%99s%20take%20a%20look%20at%20how%20each%20dataset%20query%20is%20writing.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20DataSet1%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%3C%2FP%3E%0A%20%20%3CPRE%3E%3CPRE%3E%E2%80%9C%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DSelect%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ESelect%3C%2FA%3E%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3EQFE.HotFixID0%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DFrom%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EFrom%3C%2FA%3E%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3EV_GS_Quick_Fix_Engineering%20QFE%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DOrder%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EOrder%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DBy%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EBy%3C%2FA%3E%20QFE.HotFixID0%E2%80%9D%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DAs%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EAs%3C%2FA%3E%20you%20can%20see%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Don%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eon%3C%2FA%3E%20this%20query%2C%20we%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Dare%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eare%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Dusing%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eusing%3C%2FA%3E%20the%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DView%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EView%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Dand%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eand%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Dnot%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Enot%3C%2FA%3E%20the%20RBA%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DFunction%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EFunction%3C%2FA%3E.%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3EDataSet2%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%E2%80%9C%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DSelect%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ESelect%3C%2FA%3E%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3EQFE.ResourceID%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%2Csys.Netbios_name0%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%2CQFE.Caption0%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Das%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eas%3C%2FA%3E%20%E2%80%98URL%20Info%E2%80%99%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%2CQFE.Description0%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Das%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eas%3C%2FA%3E%20%E2%80%98Classification%E2%80%99%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%2CQFE.HotFixID0%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Das%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eas%3C%2FA%3E%20%E2%80%98KB%20Article%E2%80%99%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%2CQFE.InstalledBy0%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Das%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eas%3C%2FA%3E%20%E2%80%98Installed%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DBy%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EBy%3C%2FA%3E%E2%80%99%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%2CQFE.InstalledOn0%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Das%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eas%3C%2FA%3E%20%E2%80%98Installed%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DDate%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EDate%3C%2FA%3E%E2%80%99%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DFROM%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EFROM%3C%2FA%3E%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3EV_GS_Quick_Fix_Engineering%20QFE%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DLEFT%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ELEFT%3C%2FA%3E%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DJoin%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EJoin%3C%2FA%3E%20v_r_system%20sys%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Don%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eon%3C%2FA%3E%20qfe.resourceid%20%3D%20sys.resourceid%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3CPRE%3E%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3DWhere%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EWhere%3C%2FA%3E%20qfe.HotFixID0%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Dlike%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Elike%3C%2FA%3E%20%40HotFix%E2%80%9D%3CBR%20%2F%3E%3C%2FPRE%3E%3CPRE%3E%3C%2FPRE%3E%3C%2FPRE%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20Now%20let%E2%80%99s%20start%20by%20adding%20the%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20DataSetAdminID%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%20to%20the%20Report.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20To%20do%20this%20go%20to%20Datasets%2C%20right%20click%20Add%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20DataSet%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20In%20the%20Name%20Field%20enter%3A%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20DataSetAdminID%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20Click%20Use%20a%20dataset%20embedded%20in%20my%20report%3A%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20Select%20the%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20Data%20Source%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%20%3A%20Should%20be%20the%20ConfigMgr%20Default%20data%20source%20or%20a%20custom%20one.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20In%20the%20Query%20enter%20the%20following%20query%20statement%3A%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CPRE%3E%3CPRE%3E%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Dselect%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eselect%3C%2FA%3E%20dbo.fn_rbac_GetAdminIDsfromUserSIDs%20(%40UserTokenSIDs)%20%3CA%20href%3D%22http%3A%2F%2Fsearch.microsoft.com%2Fdefault.asp%3Fso%3DRECCNT%26amp%3Bsiteid%3Dus%252Fdev%26amp%3Bp%3D1%26amp%3Bnq%3DNEW%26amp%3Bqu%3Das%26amp%3BIntlSearch%3D%26amp%3Bboolean%3DPHRASE%26amp%3Big%3D01%26amp%3Bi%3D09%26amp%3Bi%3D99%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Eas%3C%2FA%3E%20UserSIDs%3C%2FPRE%3E%3C%2FPRE%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20%3CIMG%20alt%3D%22clip_image014%22%20border%3D%220%22%20height%3D%22425%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134593iF75411440A33629D%22%20title%3D%22clip_image014%22%20width%3D%22418%22%20%2F%3E%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20Click%20OK%20to%20finish%20the%20new%20dataset.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20%3CIMG%20alt%3D%22clip_image016%22%20border%3D%220%22%20height%3D%22447%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134594i3772FF612750F9C0%22%20title%3D%22clip_image016%22%20width%3D%22226%22%20%2F%3E%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20The%20dataset%20has%20been%20added%20and%20also%20a%20new%20prompt.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20Let%E2%80%99s%20now%20modify%20the%20query%20on%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20Dataset1%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%20and%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20Dataset2%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%20to%20use%20the%20RBAC%20function.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20%3CIMG%20alt%3D%22clip_image018%22%20border%3D%220%22%20height%3D%22390%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134595i0EE74935C2650C60%22%20title%3D%22clip_image018%22%20width%3D%22518%22%20%2F%3E%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20Dataset1%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%20has%20been%20changed%3B%20all%20I%20did%20was%20replace%0A%20%20%20%3CFONT%3E%0A%20%20%20%20%3CSTRONG%3E%0A%20%20%20%20%20V_%0A%20%20%20%20%3C%2FSTRONG%3E%0A%20%20%20%3C%2FFONT%3E%0A%20%20%20to%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20%3CFONT%3E%0A%20%20%20%20%20fn_rbac%0A%20%20%20%20%3C%2FFONT%3E%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%20and%20add%20the%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20(%40UserSIDs).%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20%3CIMG%20alt%3D%22clip_image020%22%20border%3D%220%22%20height%3D%22396%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134596iA46B62A31741DE56%22%20title%3D%22clip_image020%22%20width%3D%22524%22%20%2F%3E%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20Here%20is%20the%20updated%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20DataSet2%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%20.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20On%20the%20parameters%2C%20move%20the%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20UserTokenSIDs%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%20as%20the%20first%20priority.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20%3CIMG%20alt%3D%22clip_image022%22%20border%3D%220%22%20height%3D%22495%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F134597i00F37E610217D669%22%20title%3D%22clip_image022%22%20width%3D%22254%22%20%2F%3E%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20And%20that%E2%80%99s%20all%20you%20will%20need%20to%20do%20to%20convert%20your%20custom%20report%20from%20non%20RBA%20to%20use%20RBA%20Function%20for%20reports%2C%20I%20hope%20these%20instructions%20were%20helpful%20and%20you%20can%20create%20your%20new%20reports%20ready%20for%20RBA.%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20as%20a%20bonus%20for%20reading%20this%20blog%20post%20I%20have%20uploaded%20the%20template%20reports%20I%20used%20for%20this%20blog%20post%20here%3A%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20%3CA%20href%3D%22http%3A%2F%2Fgallery.technet.microsoft.com%2FQuick-Fix-Engineering-0e9fb49c%22%20title%3D%22http%3A%2F%2Fgallery.technet.microsoft.com%2FQuick-Fix-Engineering-0e9fb49c%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%0A%20%20%20%20http%3A%2F%2Fgallery.technet.microsoft.com%2FQuick-Fix-Engineering-0e9fb49c%0A%20%20%20%3C%2FA%3E%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CH3%20id%3D%22toc-hId--924799104%22%20id%3D%22toc-hId--924744511%22%3E%0A%20%20%20Does%20this%20information%20help%20you%3F%0A%20%20%3C%2FH3%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20%3CEM%3E%0A%20%20%20%20%20Happy%20Thanksgiving!!%0A%20%20%20%20%3C%2FEM%3E%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20Santos%20Martinez%20%E2%80%93%20Sr.%20PFE%20%E2%80%93%20ConfigMgr%20and%20Databases%0A%20%20%3C%2FP%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CBR%20%2F%3E%0A%20%20%3CP%3E%0A%20%20%20%3CSTRONG%3E%0A%20%20%20%20Disclaimer%3A%0A%20%20%20%3C%2FSTRONG%3E%0A%20%20%20The%20information%20on%20this%20site%20is%20provided%20%22AS%20IS%22%20with%20no%20warranties%2C%20confers%20no%20rights%2C%20and%20is%20not%20supported%20by%20the%20authors%20or%20Microsoft%20Corporation.%20Use%20of%20any%20included%20script%20samples%20are%20subject%20to%20the%20terms%20specified%20in%20the%0A%20%20%20%3CA%20href%3D%22http%3A%2F%2Fwww.microsoft.com%2Finfo%2Fcpyright.mspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%0A%20%20%20%20Terms%20of%20Use%0A%20%20%20%3C%2FA%3E%0A%20%20%3C%2FP%3E%0A%20%20%3CDIV%20style%3D%22clear%3Aboth%22%3E%0A%20%20%3C%2FDIV%3E%0A%20%20%3CP%3E%0A%20%20%20%3CBR%20%2F%3E%0A%20%20%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-884624%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20TECHNET%20on%20Nov%2028%2C%202013%20Authored%20by%20Santos%20MartinezHello%20all%2C%20ConfigNinja%20here%20trying%20to%20show%20you%20a%20few%20tips%20and%20tricks%20to%20convert%20your%20current%20custom%20reports%20using%20the%20new%20RBA(Role%20Based%20Administration)%20for%20reports.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-884624%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Econfigmgr%202012%20r2%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ereporting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
First published on TECHNET on Nov 28, 2013

Authored by Santos Martinez


Hello all, ConfigNinja here trying to show you a few tips and tricks to convert your current custom reports using the new RBA(Role Based Administration) for reports. http://technet.microsoft.com/en-us/library/dn236351.aspx#BKMK_WhatsNew_Monitoring_and_Reporting... This new feature on R2 brings  lots of benefits, especially for those users that don’t need to have access to all the data within ConfigMgr and limit what you allow them to view. Read more about this here, http://technet.microsoft.com/en-us/library/7ca322fc-bbbf-42c8-82c9-6fc8941ef2e6#BKMK_RoleBaseAd...

STB13_Csonger_03

Modify a custom report

We are going to modify your custom report using Report Builder, Once you have the Report Builder open we will review a few things before updating your new custom report.

First let’s review one of the new reports from ConfigMgr 2012 R2, at your SSRS Website http://cmsite/reports.

Next, let’s go to Software Distribution - Collections > All resources in a specific collection click on the drop down and select edit in Report Builder.

Now that you are on Report Builder, let’s review a few details that are new on this report.

clip_image002

We have UserTokenSIDs and UserSIDS on the Parameters section; also we have a new Dataset call DataSetAdminID .

Let’s review the query inside the DataSetAdminID :

select dbo.fn_rbac_GetAdminIDsfromUserSIDs (@UserTokenSIDs) as UserSIDs”



Now let’s review the 2 prompts that are part of my report.



@UserTokenSIDs general Configuration:



clip_image004



Available Values leave as default that should be NONE.



clip_image006



Default Values, Specify values.



The value will be an expression, click on the expression button to see the expression code.



=SrsResources.UserIdentity.GetUserSIDs(User!UserID)


Leave this as the default.



Let’s review @UserSIDs Prompt



clip_image008



On the Available Values page, leave as default wich should be NONE



Review the Default Values page and other pages but do not make changes.



clip_image010



Now that we understand the prompt let’s review the main Datasets of this reports and review the code.



On the DataSet1 , the code is as follow.



Select Distinct CollectionID, Name FROM fn_rbac_collection(@UserSIDs) order by Name”



This T-SQL Code in the past use to be like this:



Select Distinct CollectionID, Name FROM v_Collection Order By Name”



We had replaced the view for a function, and with the replace of a V_ we need to add fn_rbac_ and then after the function or view add (@UserSIDs).



Let’s take a look at the Dataset2 , here is the query inside this dataset.

Select fcm.Name,
CASE WHEN coll.CollectionType=1 THEN fcm.SMSID ELSE fcm.Name END as Is,
CASE WHEN ResourceType = 3 THEN ‘*’ ELSE ‘’ END as C066,
CASE WHEN ResourceType = 4 THEN ‘*’ ELSE ‘’ END as C067,
CASE WHEN ResourceType = 5 THEN ‘*’ ELSE ‘’ END as C068,
SiteCode,
CASE IsDirect
When 1 THEN ‘*’
When 0 THEN ‘’
END AS C069,
Coll.CollectionType
From fn_rbac_FullCollectionMembership (@UserSIDs) fcm
INNER JOIN fn_rbac_collection(@UserSIDs) coll on fcm.CollectionID = coll.CollectionID
Where fcm.CollectionID = @ID”

As you can see on this query, the query had been modified to first validate the UserSIDs before displaying the report data.



Now let’s convert a custom report without Role Based Administration into using RBA.



For this, I will modify a Quick Fix Engineering Report that was created without RBA.



clip_image012



As you can see on this image, there is a missing Prompt and a missing data set from this report.



Plus let’s take a look at how each dataset query is writing.



DataSet1

Select
QFE.HotFixID0
From
V_GS_Quick_Fix_Engineering QFE
Order By QFE.HotFixID0”
As you can see on this query, we are using the View and not the RBA Function.
DataSet2
Select
QFE.ResourceID
,sys.Netbios_name0
,QFE.Caption0 as ‘URL Info’
,QFE.Description0 as ‘Classification’
,QFE.HotFixID0 as ‘KB Article’
,QFE.InstalledBy0 as ‘Installed By
,QFE.InstalledOn0 as ‘Installed Date
FROM
V_GS_Quick_Fix_Engineering QFE
LEFT Join v_r_system sys on qfe.resourceid = sys.resourceid
Where qfe.HotFixID0 like @HotFix”

Now let’s start by adding the DataSetAdminID to the Report.



To do this go to Datasets, right click Add DataSet



In the Name Field enter: DataSetAdminID



Click Use a dataset embedded in my report:



Select the Data Source : Should be the ConfigMgr Default data source or a custom one.



In the Query enter the following query statement:



select dbo.fn_rbac_GetAdminIDsfromUserSIDs (@UserTokenSIDs) as UserSIDs



clip_image014



Click OK to finish the new dataset.



clip_image016



The dataset has been added and also a new prompt.



Let’s now modify the query on Dataset1 and Dataset2 to use the RBAC function.



clip_image018



Dataset1 has been changed; all I did was replace V_ to fn_rbac and add the (@UserSIDs).



clip_image020



Here is the updated DataSet2 .



On the parameters, move the UserTokenSIDs as the first priority.



clip_image022



And that’s all you will need to do to convert your custom report from non RBA to use RBA Function for reports, I hope these instructions were helpful and you can create your new reports ready for RBA.



as a bonus for reading this blog post I have uploaded the template reports I used for this blog post here:



http://gallery.technet.microsoft.com/Quick-Fix-Engineering-0e9fb49c



Does this information help you?



Happy Thanksgiving!!



Santos Martinez – Sr. PFE – ConfigMgr and Databases



Disclaimer: The information on this site is provided "AS IS" with no warranties, confers no rights, and is not supported by the authors or Microsoft Corporation. Use of any included script samples are subject to the terms specified in the Terms of Use