Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
Solved
SCCM Report - Update Installed software on a specific computer Report to run against Collection
Posted on 2013-12-05
Hello SCCM Experts - Any assistance you can provide would be greatly appreciated!
I am trying to edit the current SCCM 2007 Report - "2E - Installed software on a specific computer" so it will report against a collection than a single computer.
The current report SQL Report is below, what should I update that it will allow the use of a collection? What are your thoughts?
Select distinct
v_R_System_Valid.Netbios_N
v_GS_INSTALLED_SOFTWARE_CA
"Publisher" = CASE when (v_GS_INSTALLED_SOFTWARE_C
Else v_GS_INSTALLED_SOFTWARE_CA
End,
"Version" = CASE when (v_GS_INSTALLED_SOFTWARE_C
Else v_GS_INSTALLED_SOFTWARE_CA
End,
"Language" = CASE when (v_GS_INSTALLED_SOFTWARE_C
Else CAST(v_GS_INSTALLED_SOFTWA
End,
v_GS_INSTALLED_SOFTWARE_CA
v_GS_INSTALLED_SOFTWARE_CA
v_GS_INSTALLED_SOFTWARE_CA
v_GS_INSTALLED_SOFTWARE_CA
v_GS_INSTALLED_SOFTWARE_CA
v_GS_INSTALLED_SOFTWARE_CA
"Installed Location" = CASE when (v_GS_INSTALLED_SOFTWARE_C
Else v_GS_INSTALLED_SOFTWARE_CA
End,
"Install Source" = CASE when (v_GS_INSTALLED_SOFTWARE_C
Else v_GS_INSTALLED_SOFTWARE_CA
End,
"Uninstall String" = CASE when (v_GS_INSTALLED_SOFTWARE_C
Else v_GS_INSTALLED_SOFTWARE_CA
End,
"Install Date" = CASE when (v_GS_INSTALLED_SOFTWARE_C
Else CAST(v_GS_INSTALLED_SOFTWA
End,
"Registered User" = CASE when (v_GS_INSTALLED_SOFTWARE_C
Else v_GS_INSTALLED_SOFTWARE_CA
End
FROM v_GS_INSTALLED_SOFTWARE_CA
INNER JOIN v_R_System_Valid on v_R_System_Valid.ResourceI
Where v_R_System_Valid.Netbios_N
order by v_GS_INSTALLED_SOFTWARE_CA
I am trying to edit the current SCCM 2007 Report - "2E - Installed software on a specific computer" so it will report against a collection than a single computer.
The current report SQL Report is below, what should I update that it will allow the use of a collection? What are your thoughts?
Select distinct
v_R_System_Valid.Netbios_N
v_GS_INSTALLED_SOFTWARE_CA
"Publisher" = CASE when (v_GS_INSTALLED_SOFTWARE_C
Else v_GS_INSTALLED_SOFTWARE_CA
End,
"Version" = CASE when (v_GS_INSTALLED_SOFTWARE_C
Else v_GS_INSTALLED_SOFTWARE_CA
End,
"Language" = CASE when (v_GS_INSTALLED_SOFTWARE_C
Else CAST(v_GS_INSTALLED_SOFTWA
End,
v_GS_INSTALLED_SOFTWARE_CA
v_GS_INSTALLED_SOFTWARE_CA
v_GS_INSTALLED_SOFTWARE_CA
v_GS_INSTALLED_SOFTWARE_CA
v_GS_INSTALLED_SOFTWARE_CA
v_GS_INSTALLED_SOFTWARE_CA
"Installed Location" = CASE when (v_GS_INSTALLED_SOFTWARE_C
Else v_GS_INSTALLED_SOFTWARE_CA
End,
"Install Source" = CASE when (v_GS_INSTALLED_SOFTWARE_C
Else v_GS_INSTALLED_SOFTWARE_CA
End,
"Uninstall String" = CASE when (v_GS_INSTALLED_SOFTWARE_C
Else v_GS_INSTALLED_SOFTWARE_CA
End,
"Install Date" = CASE when (v_GS_INSTALLED_SOFTWARE_C
Else CAST(v_GS_INSTALLED_SOFTWA
End,
"Registered User" = CASE when (v_GS_INSTALLED_SOFTWARE_C
Else v_GS_INSTALLED_SOFTWARE_CA
End
FROM v_GS_INSTALLED_SOFTWARE_CA
INNER JOIN v_R_System_Valid on v_R_System_Valid.ResourceI
Where v_R_System_Valid.Netbios_N
order by v_GS_INSTALLED_SOFTWARE_CA
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
Firstly, you could change all the " to ' to get the query to work correctly in T-SQL
Then if your current single machine is denoted by
If you're doing this in, for example, an SSRS report and you are also changing your input from a single name in a drop-list to a drop-list where you can select multiple names then what you'll get a string of server names, like 'Fred,Bill,Jim', instead of a single value for @name like 'Fred' for the server. If that is the case, but the query should remain the same, you'll need a slightly different way of doing things so that you can accept the list of servers.
Please answer stating what kind of input the query will get with multiple servers (with example!) .
hth
Mike
Then if your current single machine is denoted by
Where v_R_System_Valid.Netbios_Name0 = @Name
where v_R_System_Valid.Netbios_Name0 in (@Name1, @Name2, @Name3)
If you're doing this in, for example, an SSRS report and you are also changing your input from a single name in a drop-list to a drop-list where you can select multiple names then what you'll get a string of server names, like 'Fred,Bill,Jim', instead of a single value for @name like 'Fred' for the server. If that is the case, but the query should remain the same, you'll need a slightly different way of doing things so that you can accept the list of servers.
Please answer stating what kind of input the query will get with multiple servers (with example!) .
hth
Mike
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job.
The first step is to acquire the necessary licen…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders.
Click on Start and then select Computer to view the available drives on the se…
Suggested Courses
Course of the Month11 days, 16 hours left to enroll
730 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.