(/connect/)
Forums (/connect/forums/community-forums)
Client Management Suite (/connect/endpoint-management/forums/client-management)
Thread Needs Solution
Active Clients Computer Summary Report By: Clint (/connect/user/clint) Created 18 Dec 2013 0
10 Comments
(http://en-us.reddit.com/submit?url=http://www.symantec.com/connect/forums/active-clients-computer-summary-report)
0
(/connect/forward?path=node/3021291)
Like 0
In ITMS 7.1, there's a "Computer Summary" report under Reports->Discovery and Inventory->Inventory->Cross-platform->Operating System. I'd like to modify it to include only clients who've checked in with the server within the last 30 days. For my old Altiris 6 server, I set my data purging to 30 days so reports would always have fairly current info. Yah...I know I could do the same with 7.1 although figured maybe I should do some research on cloning/modifying the existing Computer Summary report in case someone wants historic inventory data in the future. Operating Systems: Windows Server (2003/2008) (/connect/operating-system/windows-server-20032008) Tags: Endpoint Management (/connect/search?filters=im_vid_31:731), Client Management Suite - 7.x (/connect/product/client-management-suite), Client Management Suite (/connect/product/client-management-suite), Configuring (/connect/search?filters=im_vid_4:843), Windows Server (2003/2008) (/connect/search?filters=im_vid_171:61821) Subscriptions (0)
Was this post helpful to you? Yes No Dismiss Be the first to mark this helpful.
(/connect/user/clint) Clint (/connect/user/clint) View Profile (/connect/user/clint)
Jump to latest comment
10 Comments (/connect/user/james3) James007 (/connect/user/james3)
How to get a quick count of active machines on a client facing NS? https://www-secure.symantec.com/connect/blogs/how-get-quick-count-active-machines-client-facing-ns (https://www-secure.symantec.com/connect/blogs/howget-quick-count-active-machines-client-facing-ns)
Login (/connect/user/login?destination=forums%2Factive-clients-computer-summary-report) or Register (/connect/user/register?destination=forums%2Factive-clients-computer-summary-report) to post comments. 18 Dec 2013 (/connect/forums/active-clients-computer-summary-report#comment-9618081)
(/connect/user/aj01) AJ_01 (/connect/user/aj01)
Hope the below thread help you https://www-secure.symantec.com/connect/forums/rep... (https://www-secure.symantec.com/connect/forums/report-non-active-systems#comment-8814721) Regard AJ
Login (/connect/user/login?destination=forums%2Factive-clients-computer-summary-report) or Register (/connect/user/register?destination=forums%2Factive-clients-computer-summary-report) to post comments. 18 Dec 2013 (/connect/forums/active-clients-computer-summary-report#comment-9618331)
(/connect/user/sk) SK (/connect/user/sk)
SYMANTEC EMPLOYEE
ACCREDITED
Yes you can clone and then modify the reports SQL so that it includes the extra syntax. Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.
Login (/connect/user/login?destination=forums%2Factive-clients-computer-summary-report) or Register (/connect/user/register?destination=forums%2Factive-clients-computer-summary-report) to post comments. 19 Dec 2013 (/connect/forums/active-clients-computer-summary-report#comment-9620271)
(/connect/user/gavin-sanish) Gavin Sanish (/connect/user/gavin-sanish)
Hi Clint, You can check the following query, here you can find the list of active computers(with Agent) and how many days it has not registered. SELECT vc.Name, vc.Domain, vc.[OS Name], ictr.IsActive, ictr.LastRegistered, DATEDIFF(dd, ictr.LastRegistered, GETDATE()) AS Days, ihld.Manufacturer, ihld.Model, ihld.[Device ID] FROM dbo.vComputer AS vc LEFT OUTER JOIN dbo.vHWComputerSystem AS ihld ON vc.Guid = ihld._ResourceGuid LEFT OUTER JOIN dbo.Inv_Client_Task_Resources AS ictr ON vc.Guid = ictr._ResourceGuid WHERE (ictr.IsActive = 1) AND (DATEDIFF(dd, ictr.LastRegistered, GETDATE()) < 30) --
...
G. Gavin Sanish T : +91 9884877206 &a Login (/connect/user/login?destination=forums%2Factive-clients-computer-summary-report) or Register (/connect/user/register?destination=forums%2Factive-clients-computer-summary-report) to post comments. 19 Dec 2013 (/connect/forums/active-clients-computer-summary-report#comment-9620941)
(/connect/user/clint) Clint (/connect/user/clint)
I created a SQL report with this code although I didn't see any of my test VMs in them which had configuration requests within the past week. Perhaps I'm misunderstanding what "IsActive" or "LastRegistered" implies? Clint
Login (/connect/user/login?destination=forums%2Factive-clients-computer-summary-report) or Register (/connect/user/register?destination=forums%2Factive-clients-computer-summary-report) to post comments. 19 Dec 2013 (/connect/forums/active-clients-computer-summary-report#comment-9622381)
(/connect/user/sk) SK (/connect/user/sk)
SYMANTEC EMPLOYEE
ACCREDITED
Utilise the SQL contained within the spGetComputersToPurge stored procedure, but change the WHERE clause to use the following: < DATEADD(DAY,-30,GETDATE()) Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.
Login (/connect/user/login?destination=forums%2Factive-clients-computer-summary-report) or Register (/connect/user/register?destination=forums%2Factive-clients-computer-summary-report) to post comments. 20 Dec 2013 (/connect/forums/active-clients-computer-summary-report#comment-9624221)
(/connect/user/clint) Clint (/connect/user/clint)
Just curious whether you guys just left Purging Maintenance at the default 6 months in your SMC or cut it down to, say, 1 month so you wouldn't have to deal with having stale info in your database? As an additional benefit, setting purge maintenance lower should also speed up overall data access since the server wouldn't have to comb through 6 months worth of stuff for reports/filters. Think it's rare that someone would want historical data from Altiris...at least from my experience. My old Altiris 6 server hardware was nothing in comparison to my SMP 7.1 server so I was somewhat forced to be more aggressive with purging maintenance. Even though I can manage more data now, maybe it's still not worth it? Clint
Login (/connect/user/login?destination=forums%2Factive-clients-computer-summary-report) or Register (/connect/user/register?destination=forums%2Factive-clients-computer-summary-report) to post comments. 19 Dec 2013 (/connect/forums/active-clients-computer-summary-report#comment-9622501)
(/connect/user/sk) SK (/connect/user/sk)
SYMANTEC EMPLOYEE
ACCREDITED
Historical data is determined by the companies data retention policy. I have had one customer that required three years worth of data which had its painful momernts. Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.
Login (/connect/user/login?destination=forums%2Factive-clients-computer-summary-report) or Register (/connect/user/register?destination=forums%2Factive-clients-computer-summary-report) to post comments. 20 Dec 2013 (/connect/forums/active-clients-computer-summary-report#comment-9624271)
(/connect/user/clint) Clint (/connect/user/clint)
FYI: I spoke to upper management here where we have no stated desktop data retention policy so decided to spare myself some grief and set purging maintenance down to 1 month from 6. Clint
Login (/connect/user/login?destination=forums%2Factive-clients-computer-summary-report) or Register (/connect/user/register?destination=forums%2Factive-clients-computer-summary-report) to post comments. 23 Dec 2013 (/connect/forums/active-clients-computer-summary-report#comment-9631231)
(/connect/user/gavin-sanish) Gavin Sanish (/connect/user/gavin-sanish)
Hi clint, Is active =1 means the agent installed machine if you changed the value to 0, you can find the unmanaged machines. --
...
G. Gavin Sanish T : +91 9884877206 &a Login (/connect/user/login?destination=forums%2Factive-clients-computer-summary-report) or Register (/connect/user/register?destination=forums%2Factive-clients-computer-summary-report) to post comments. 20 Dec 2013 (/connect/forums/active-clients-computer-summary-report#comment-9625481)
This thread is locked. Please start a new discussion.
About Your Community A Message From Your Community Manager: A L Johnson (/connect/user/l-johnson) Welcome to the Endpoint Management Community. The Endpoint Management Community covers many different endpoint management products from Symantec and provides valuable technical information for each.
(/connect/user/l-johnson)
Please feel free to contact me via private message with any questions you may have. I look forward to hearing from you and answering any questions about the Community. Send a private message to the Community Manager (/connect/messages/new/2785391?destination=user%2F2785391) Top 5 Contributors: All Time MEMBER
REWARD POINTS
(/connect/user/joel-smith) Joel Smith (/connect/user/joel-smith)
80368
(/connect/user/ianatkin) ianatkin (/connect/user/ianatkin)
56898
(/connect/user/edt) EdT (/connect/user/edt)
32634
(/connect/user/alexhedley) AlexHedley (/connect/user/alexhedley)
24546
(/connect/user/mclemson) mclemson (/connect/user/mclemson)
19681
Top 5 Contributors: Last 30 Days MEMBER
REWARD POINTS
(/connect/user/brycenm) BrycenM (/connect/user/brycenm)
50
(/connect/user/stefan-s) Stefan S. (/connect/user/stefan-s)
50
(/connect/user/joeliglesias) joel.iglesias (/connect/user/joeliglesias)
50
(/connect/user/srinivasan-balaraman) Srinivasan Balaraman (/connect/user/srinivasan-balaraman)
5
(/connect/user/telefragger) TeleFragger (/connect/user/telefragger)
1
Trusted Advisors MEMBER
ARTICLES SOLVED
(/connect/user/angeld) AngelD (/connect/user/angeld)
0
77
(/connect/user/edt) EdT (/connect/user/edt)
12
676
(/connect/user/hightower) HighTower (/connect/user/hightower)
1
95
(/connect/user/jasoni) JasonI (/connect/user/jasoni)
8
5
(/connect/user/justin-dyb-dahl) Justin Dybedahl (/connect/user/justin-dyb-dahl)
1
39
(/connect/user/sally5432) Sally5432 (/connect/user/sally5432)
7
37
(/connect/user/africo) africo (/connect/user/africo)
39
74
(/connect/user/andykn101) andykn101 (/connect/user/andykn101)
2
273
(/connect/user/ianatkin) ianatkin (/connect/user/ianatkin)
78
175
Contact Us (/connect/contact) Privacy Policy (http://www.symantec.com/about/profile/policies/privacy.jsp) Earn Rewards (/connect/points) Rewards Terms and Conditions (/connect/blogs/symantec-connect-rewards-program-terms-and-conditions) © 2018 Symantec Corporation (https://twitter.com/symantec)
(https://www.facebook.com/Symantec)
(https://www.linkedin.com/company/symantec)