I was wanting to save the results of a filter to an Excel file today, and I found that the filter did not have a "Save As" button. I found an article here that explained it, but I modified the report slightly to fit my needs. I was looking for way to get the list of computers in my Patch Test Group Filter. I used this SQL query to create a report to then save as a .csv:

SELECT Distinct 

r.Guid AS '_ItemGuid', 

r.Name AS 'Resource', 

r.[User], 

r.[System Type], 

r.[OS Name], 

vItem.Name AS FilterName

FROM 

vItem INNER JOIN

CollectionMembership INNER JOIN

vComputerEx AS r ON CollectionMembership.ResourceGuid = r.Guid ON 

vItem.Guid = CollectionMembership.CollectionGuid LEFT OUTER JOIN

Inv_AeX_AC_Identification ON r.Guid = Inv_AeX_AC_Identification._ResourceGuid

WHERE

CollectionMembership.CollectionGuid = 'd0fae853-3129-490f-86fd-e8a8bc0162f2'

ORDER BY r.Name ASC

All you need to change on this report os...

Hello Everyone,

I thought i would share this with you all, it is a webcast on Symantec best practice approach to effective patch management for clients and servers.

Effective Patch Management for Clients and Servers

An effective and comprehensive patch management strategy is an essential part of a solid security defense. The vast majority of vulnerabilities exploited by malicious code are ones for which a fix is available from the software vendor. A recent Gartner report stated that “90% of successful attacks occurred against previously known vulnerabilities where a patch or secure configuration standard was already available.”1 (‘Managing the Next Generation of Client Computing,’ Terrance Cosgrove, Gartner, February 8, 2011)

Attend our webcast to learn how to build and roll-out a complete patch management strategy to:

•Ensure that Windows, Mac, Red Hat®...

The Royal Liverpool and Broadgreen University Hospitals NHS Trust is one of North England’s busiest and largest hospitals. With the influx of mobile devices impacting healthcare, the Trust embarked on a mobile data management strategy, based on Symantec Mobile Management, to enable secure mobile working. As a result, it found clinical outcomes improved through real-time access to healthcare history, medical images, medical notes, and more. All of this comes on top of a highly successful Symantec data loss prevention (DLP) and endpoint security implementation that lowers the cost of managing security by 25 percent. To learn more about these highly successful mobile management and security strategies, follow this link: http://bit.ly/VqUeD2     

https://www.publicsector.shidirect.com/Webinars/SeminarRegister.aspx?SeminarSeriesId=813

I just wanted to post this event on the connect page and see if anyone else from the user group planned on attending?  WKU will have a few folks there.