Patch Management Group

Hi All ,

We are having workgroup environment and there are many computer with same hostname, so we are looking to try adding IP address field in defaul windows compliance by computer.

Does any one have any idea how to get this report as windows compliance by computer is not a query base report ,it a Stored Procedure so we are struggling a lot for it .

Hope you all understand my problem and if anyone has any update do update me.

Regards,

Sudarshan

Hi Sudarshamp.

Once I needed a custom Patch Management Report and the unique way out was to clone the procedure and customize by myself.

I suggest you clone the procedure, make the changes and then create a custom Patch Management report using this new customized procedure.

Maybe the article bellow can help you with this process. It helped me!

https://www-secure.symantec.com/connect/forums/how-create-custom-patch-management-compliance-report

Regards,

Take a look at the customer SQL Query attached from INFO2905 as it displays the following columns:

• Computer Name
• IP Address
• Bulletin: Update Name
• Update Severity
• IsInstalled
• Install Start Date
• Status
• Downloaded
• Vendor
• Reboot Required

This script is one that I share often when details are needed in Compliance Reports to show which tables that data is found in (e.g. IP Addresses are found in vComputer).

Note: This query returns a very high count of data as each line item is for each targeted Software Update for each Client Machine, so run this in SQL only if you need to view this completed script.

Attachment(s)

SQL Query - Ultimate Patch Report_5 - All Clients & Bulle...txt   3 KB 1 version

Hi Sudarshamp

Our experience with including something like the IP address field results in confusion in the information.  At least in our DHCP environment, many machines get multiple IP addresses because of WiFi networks, VPNs, etc.  These IPs get changed regularly and therefore the information collected by Symantec would be out of date and for each IP address you will get the same patch data greatly increasing the amount of data.

In my opinion, you would be far better served by dealing with the duplicate hostname issue you have.  The report that Joshua provided appears to do what you want but as his warning states, it brings back a high count of data.

Thanks all for reppling and sorry for not reppling as i was out of town but still all of you didnot got my point we want the default report only but in that report add IP address row only.

Regards,

Sudarshan

Sudarshanp, I believe that Fernando did answer your question specifically but did not provide a step by step.  Cloning of the stored procedure is something well past my expertise but the link he provided looks like it has enough details.  You would most likely need a DBA to assist as is suggested in the thread.

Cheers.