It's all right here: select top 10 * from [dbo].[v_GS_INSTALLED_SOFTWARE_CATEGORIZED]
Join it to v_r_system and you have a starting point. select v_r_system.netbios_name0, [dbo].[v_GS_INSTALLED_SOFTWARE_CATEGORIZED].* from [dbo].[v_GS_INSTALLED_SOFTWARE_CATEGORIZED] join v_r_system on v_R_system.resourceid = [dbo].[v_GS_INSTALLED_SOFTWARE_CATEGORIZED].resourceid where CategoryName = 'Put-the-category-name-here' From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, September 24, 2015 1:01 PM To: [email protected] Subject: [mssms] Report for Asset Intelligence - Systems with software in a particular product category? Hello everyone, Before I spend *waaaay* more time than I wish trying to figure out how to do this, has anyone created an SSRS report that will, based on Asset Intelligence information, display all systems that have software (and what software it is) within a specified AI product category? The canned "Software 02C" report will display all products in a specific category, but there's no way to display a top-level report of all systems with software in that category. You have to drill down on each entry individually - unless I am missing something? Thanks in advance, Andrew _____ This e-mail is intended only for the person or entity to whom it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. If you are not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of this message is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the original message and all copies from your system. Statements and representations made in this message are not necessarily that of the Company.
