• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1147
  • Last Modified:

SCCM Update Repository Search by Collection

I would like to create a Search Folder for All Updates to a particular Collection.  Can this be done?
0
mdmcq5
Asked:
mdmcq5
  • 6
  • 6
  • 2
1 Solution
 
merowingerCommented:
No as the Search Folder Criteria is only based on Update Information.
What you could do is to create a ConfigMgr Report for your needs.
Maybe you'll find some Reports Samples here:
http://pleasepressanykey.blogspot.com/2010/08/sccm-patchmgmt-custom-reports.html
0
 
mdmcq5Author Commented:
I ran this code:
select  
v_Collection.Name as CollectionName,  
v_ServiceWindow.Description,  
v_FullCollectionMembership.Name as Computername    
from v_ServiceWindow  
inner join v_FullCollectionMembership on (v_FullCollectionMembership.CollectionID = v_ServiceWindow.CollectionID)  
inner join v_Collection on (v_Collection.CollectionID = v_FullCollectionMembership.CollectionID)  
order By v_Collection.Name

but it isn't pulling all my collections.  
0
 
George SimosIT Pro Consultant - IT Systems AdministratorCommented:
Would you like to describe exactly what you want to do please?
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
mdmcq5Author Commented:
I would like to pull a report that includes a list all updates (windows, patches, drivers, etc.) to a specific collection
0
 
merowingerCommented:
With this query you just get collections with Service Windows
0
 
George SimosIT Pro Consultant - IT Systems AdministratorCommented:
Would you like to use the built-in report named "Management 3 - Deployments that target a collection" ?
It does what you want, you select a collection and it returns any updates targeted in it.
0
 
George SimosIT Pro Consultant - IT Systems AdministratorCommented:
Alternatively you may clone another report in the management or compliance category and play around with it (tweaking it) to get the result you seek.
0
 
mdmcq5Author Commented:
gsimos, do you know this report # for Management 3 - Deployments that target a collection? If not I'll look through tomorrow.  I must have overlooked and will check...
0
 
George SimosIT Pro Consultant - IT Systems AdministratorCommented:
Yes, the only input it needs is the collection id and it returns any updates applied/needed for it.
Isn't this the one you're asking?
0
 
mdmcq5Author Commented:
when running the code, I receive an error with the @__timezoneoffset

Msg 137, Level 15, State 2, Line 7
Must declare the scalar variable "@__timezoneoffset".

How do I properly set this line?
select 
a.Assignment_UniqueID as DeploymentID,
a.AssignmentName as DeploymentName,
IncludeSubCollection = case a.IncludeSubCollections when 1 then '*' else '' end,
a.StartTime as Available,
a.EnforcementDeadline as Deadline,
DATEADD(ss,@__timezoneoffset,a.LastModificationTime) as     LastModificationTime
from v_CIAssignment a
where (@CollID is null or a.CollectionID = 'USA0001') and a.UpdateAssignment = 1
order by AssignmentName

Open in new window

0
 
George SimosIT Pro Consultant - IT Systems AdministratorCommented:
Err I lost you now mdmcq5.....
Have you tried the canned report I mentioned above? isn't it adequate for your request?

I'll try your code and let you know.

0
 
mdmcq5Author Commented:
I had accepted your answer, however it looks like it didn't save
0
 
mdmcq5Author Commented:
did the trick
0
 
George SimosIT Pro Consultant - IT Systems AdministratorCommented:
Thanks for accepting my answer, i'll let you know when i check your query.
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 6
  • 6
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now