One of the cool things about ConfigMgr is that you can add in your own tools as right click menu items. There are some really good ones out there. In my environment, I have some GUI tools I have for boundary and collection creation that are used to enforce naming standards as well as perform additional steps to help eliminate human error. I recently decided that I would like to leverage this function to open up ConfigMgr reports and pass the parameters from the console to the report.<\/p>\n
Determine report URL<\/strong> Here is my URL:<\/p>\n http:\/\/reportsvr\/Reports\/report\/ConfigMgr_ABC\/Count_Client_Versions_by_Collection<\/p>\n Determine report parameter(s)<\/strong> In my case the parameter is COLLID and it is looking for the CollectionID.<\/p>\n Determine where in console to have right click report show<\/strong> I used the script at https:\/\/www.ephingadmin.com\/create-your-own-right-click-tools\/ to show the GUIDs when I right click in the console. That is also where I learned how to make custom right click tools from so it is a good read as I will be repeating info from it.<\/p>\n Here are the common ones I use though<\/p>\n For my report, I see that the GUID is a92615d6-9df3-49ba-a8c9-6ecb0e8b956b<\/p>\n Determine what data can be pulled from console to set parameter<\/strong> There is an XML for each Node under \\AdminConsole\\XmlStorage\\ConsoleRoot in the directory your console is installed under. I found a92615d6-9df3-49ba-a8c9-6ecb0e8b956b in AssetManagementNode.xml and it uses SMS_Collection.<\/p>\n A quick search on SMS_Collection gets me this list of possible data I can pass to my report parameter.<\/p>\n Class SMS_Collection : SMS_BaseClass CollectionID is what I need to pass to the parameter and I see that it is included with SMS_Collection.<\/p>\n Formatting URL to pass parameter<\/strong> Here is the URL before and after the change<\/p>\n http:\/\/reportsvr\/Reports\/report\/ConfigMgr_ABC\/Count_Client_Versions_by_Collection<\/p>\n http:\/\/reportsvr\/ReportServer\/Pages\/ReportViewer.aspx?\/ConfigMgr_ABC\/ Count_Client_Versions_by_Collection<\/p>\n We now need to add the command the render to the URL ( &rs:Command=Render )<\/p>\n http:\/\/reportsvr\/ReportServer\/Pages\/ReportViewer.aspx?\/ConfigMgr_ABC\/ Count_Client_Versions_by_Collection&rs:Command=Render<\/p>\n The last part of the new URL is the parameter. The format is {ParameterNameFromReport]=##SUB:[ParameterFromConsole]##<\/p>\n This is the final URL<\/p>\n http:\/\/reportsvr\/ReportServer\/Pages\/ReportViewer.aspx?\/ConfigMgr_ABC\/ Count_Client_Versions_by_Collection&rs:Command=Render&CollID=##SUB:CollectionID##<\/p>\n Creating and placing XML file<\/strong> I then copy the XML file into the appropriate folder for the GUID<\/p>\n C:\\Program Files (x86)\\Microsoft Configuration Manager\\AdminConsole\\XmlStorage\\Extensions\\Actions\\a92615d6-9df3-49ba-a8c9-6ecb0e8b956b<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" One of the cool things about ConfigMgr is that you can add in your own tools as right click menu items. There are some really good ones out there. In my environment, I have some GUI tools I have for boundary and collection creation that are used to enforce naming standards as well as perform … Continue reading “Linking to ConfigMgr Reports through right click tools”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4],"tags":[],"class_list":["post-213","post","type-post","status-publish","format-standard","hentry","category-configmgr"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p98a2r-3r","post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/michaelschultz.net\/tech\/wp-json\/wp\/v2\/posts\/213","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/michaelschultz.net\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/michaelschultz.net\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/michaelschultz.net\/tech\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/michaelschultz.net\/tech\/wp-json\/wp\/v2\/comments?post=213"}],"version-history":[{"count":5,"href":"https:\/\/michaelschultz.net\/tech\/wp-json\/wp\/v2\/posts\/213\/revisions"}],"predecessor-version":[{"id":218,"href":"https:\/\/michaelschultz.net\/tech\/wp-json\/wp\/v2\/posts\/213\/revisions\/218"}],"wp:attachment":[{"href":"https:\/\/michaelschultz.net\/tech\/wp-json\/wp\/v2\/media?parent=213"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/michaelschultz.net\/tech\/wp-json\/wp\/v2\/categories?post=213"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/michaelschultz.net\/tech\/wp-json\/wp\/v2\/tags?post=213"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nThe first thing I did was figure out what report I wanted to use and get the URL. I am going to actually change the format of the URL and make some additions to pass the parameter with the URL.<\/p>\n
\nUnless you already know the name of the parameter (and I rarely do and I need to standardize my naming), open the report up in Report Builder and expand Parameters. This gives you the name of the parameter. You may also need to look over the query used so you know what the parameter is looking for.<\/p>\n
\nThis is where the fun starts. You need figure out the GUID of the menu that you want to add to and this is best done with a script that will automatically display those GUIDs.<\/p>\n\n\n
\n Right click on\u2026 <\/strong><\/td>\n GUID<\/strong><\/td>\n<\/tr>\n \n Collection<\/td>\n a92615d6-9df3-49ba-a8c9-6ecb0e8b956b<\/td>\n<\/tr>\n \n Device<\/td>\n 3fd01cd1-9e01-461e-92cd-94866b8d1f39<\/td>\n<\/tr>\n \n Package Deployment<\/td>\n adab1364-cf7d-4b07-8863-e9252e506e62<\/td>\n<\/tr>\n \n Application Deployment<\/td>\n 9a0e2197-51a4-439d-99ea-67edc451a51e<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\nOnce I have the GUID, I need find the WQL query used with it to make sure it actually pulls the data I need to pass to the parameter.<\/p>\n
\n{
\nString CollectionID;
\nSMS_CollectionRule CollectionRules[];
\nUInt32 CollectionType;
\nSInt32 CollectionVariablesCount;
\nString Comment;
\nUInt32 CurrentStatus;
\nBoolean HasProvisionedMember;
\nSInt32 IncludeExcludeCollectionsCount;
\nBoolean IsBuiltIn;
\nBoolean IsReferenceCollection;
\nUInt8 ISVData[];
\nUInt32 ISVDataSize;
\nString ISVString;
\nDateTime LastChangeTime;
\nDateTime LastMemberChangeTime;
\nDateTime LastRefreshTime;
\nString LimitToCollectionID;
\nString LimitToCollectionName;
\nSInt32 LocalMemberCount;
\nString MemberClassName;
\nSInt32 MemberCount;
\nUInt32 MonitoringFlags;
\nString Name;
\nBoolean OwnedByThisSite;
\nSInt32 PowerConfigsCount;
\nSMS_ScheduleToken RefreshSchedule[];
\nUInt32 RefreshType;
\nBoolean ReplicateToSubSites;
\nSInt32 ServiceWindowsCount;
\nBoolean UseCluster;
\n};<\/p>\n
\nIn order to include the parameter with report URL, I need to alter the URL. Unfortunately, I do not remember where I learned this as I would link to it. Basically, the URL needs to be changed to reference the use of ReportViewer.aspx.<\/p>\n
\nThe final step is to create and place the XML file. Here is the XML.<\/p>\n
\n <ShowOn><\/span><\/span><\/span>
\n <string><\/span><\/span><\/span>ContextMenu<\/string><\/span><\/span><\/span>
\n <\/ShowOn><\/span><\/span><\/span>
\n <ActionGroups><\/span><\/span><\/span>
\n <ActionDescription<\/span> Class ="Executable"<\/span> DisplayName<\/span>="Client Versions"<\/span> MnemonicDisplayName<\/span>="Client Versions"<\/span>><\/span><\/span>
\n <ShowOn><\/span><\/span><\/span>
\n <string><\/span><\/span><\/span>ContextMenu<\/string><\/span><\/span><\/span>
\n <\/ShowOn><\/span><\/span><\/span>
\n <ImagesDescription><\/span><\/span><\/span>
\n <ResourceAssembly><\/span><\/span><\/span>
\n <Assembly><\/span><\/span><\/span>AdminUI.UIResources.dll<\/Assembly><\/span><\/span><\/span>
\n <Type><\/span><\/span><\/span>Microsoft.ConfigurationManagement.AdminConsole.UIResources.Properties.Resources.resources<\/Type><\/span><\/span><\/span>
\n <\/ResourceAssembly><\/span><\/span><\/span>
\n <ImageResourceName><\/span><\/span><\/span>Add<\/ImageResourceName><\/span><\/span><\/span>
\n <\/ImagesDescription><\/span><\/span><\/span>
\n <Executable><\/span><\/span><\/span>
\n <FilePath><\/span><\/span><\/span>"C:\\Program Files\\internet explorer\\iexplore.exe"<\/FilePath><\/span><\/span><\/span>
\n <Parameters><\/span><\/span><\/span>http:\/\/reportsvr\/reportserver?\/ConfigMgr_ABC\/Count_Client_Versions_by_Collection&<\/span>rs:Command=Render&<\/span>COLLID=##SUB:CollectionID##<\/Parameters><\/span><\/span><\/span>
\n <\/Executable><\/span><\/span><\/span>
\n <\/ActionDescription><\/span><\/span><\/span>
\n <\/ActionGroups><\/span><\/span><\/span>
\n<\/ActionDescription><\/span><\/span><\/span><\/div><\/div>\n