Automating reports from within Symantec Antivirus System Center Console?
Posted on 2003-12-11
We are running SAV 8.1 managed server. I have been given the glorious task of sending out problem tickets for PCs that are not updating or scanning. Starting out, we are only concerned with systems that have not scanned or had live update defs in +14 days (considering we have laptops and people on vacations).
-approx 1300 pcs and laptops ranging from Windows 95 to xp (yes we still have some win 3.1, but I'm not counting them). adding both local systems and wan connected systems to the managed environment
-approx 150+ servers running NT, 2k, Red Hat...
Here is what I am currently doing:
1. From the Symantec System Center Console, doing an export of the information to a comma delimited file.
2. Using Excel, sorting, flipping and extracting the systems that have not updated or scanned in 14+days.
3. Sorting by groups, I am able to then copy and paste the problem child pcs into our highly advanced problem ticketing system (how long has word wrap been available???who needs it!). Then forwarding the information to our local PC tech staff in each division.
I am not a programmer (at least not a good one), and I am not a power user of database products such as Access or Crystal reports, but I can fumble through them with the best of the best.
If there is no silver bullet, low/no cost way to do all of this, then I guess what I would be looking for is a way to easily export the data from SSC to text, I can get help from our programming staff on the rest from there. Offering 500 points for some good information that can get me to the gold.
Thank you all for your amazing wealth of knowledge. You continue to impress me every day.