Home

Results 1 to 6 of 6

Thread: Report showing Bundle Version

  1. #1
    Join Date
    Oct 2007
    Posts
    30

    Report showing Bundle Version

    We have about 20% of our workstations that are not getting the ZCM update to version 10.0.3. They are still at version 10.0.1.

    Is there any way to get a report showing all of these workstations? The console is just too slow to have to click on Configuration>System Updates>...etc.

    Thanks for any advice.

  2. #2
    Join Date
    Jan 2008
    Posts
    149

    Re: Report showing Bundle Version

    I've tried a bunch of angells with zcm inventory reporting to get a definitive way to have the system report the true state of the agents unsuccessfully. I tried a few different criteria but could never nail down an exact report from the canned reports. the novell person i was working with showed me a sql query for the sybase db using the sybase gui and from there I was able to see the true agent version. I don't have the query handy right this second but i think it was displaying all the zdevice fields. with some slicing and dicing in excel i was able to get a list of device agent versions. I have put in a feature request while i was working this out to have a canned report, a device screen column for agent version or even and advanced device screen sort for agent version (there's all sorts of ways to sort in ther but not by agent version).

  3. #3
    Join Date
    Oct 2007
    Posts
    30

    Re: Report showing Bundle Version

    I found the zdevice table. In the ZenAgentVersion field there is some XML code which lists the version numbers of all the bundles. Granted there are several version numbers in this field, I was able to write a "slice-n-dice" MS Access string to pull out the first Version Number:

    Mid([ZenAgentVersion],InStr(1,[ZenAgentVersion],"registration")+23,8)

    This looks in the string for the word 'registration' then moves to the right 23 characters, then pulls out the next 8 characters, ie: 10.0.3.2, or what ever it may be.

    This is not a very definitive solution. Would you be able to send in your sql query?

    Thanks

    Quote Originally Posted by rvhskent View Post
    I've tried a bunch of angells with zcm inventory reporting to get a definitive way to have the system report the true state of the agents unsuccessfully. I tried a few different criteria but could never nail down an exact report from the canned reports. the novell person i was working with showed me a sql query for the sybase db using the sybase gui and from there I was able to see the true agent version. I don't have the query handy right this second but i think it was displaying all the zdevice fields. with some slicing and dicing in excel i was able to get a list of device agent versions. I have put in a feature request while i was working this out to have a canned report, a device screen column for agent version or even and advanced device screen sort for agent version (there's all sorts of ways to sort in ther but not by agent version).

  4. #4
    Join Date
    Jan 2008
    Posts
    149

    Re: Report showing Bundle Version

    Quote Originally Posted by jwdesselle View Post
    I found the zdevice table. In the ZenAgentVersion field there is some XML code which lists the version numbers of all the bundles. Granted there are several version numbers in this field, I was able to write a "slice-n-dice" MS Access string to pull out the first Version Number:

    Mid([ZenAgentVersion],InStr(1,[ZenAgentVersion],"registration")+23,8)

    This looks in the string for the word 'registration' then moves to the right 23 characters, then pulls out the next 8 characters, ie: 10.0.3.2, or what ever it may be.

    This is not a very definitive solution. Would you be able to send in your sql query?

    Thanks
    I'm not a database guy so I just dumped the whole zdevice table into a text file (copy and pasted after extending the total # of rows displayed from the default to 1000 so all my devices would be shown) and cut up he columns with excel.

  5. #5
    Join Date
    Apr 2009
    Location
    South Coast, England
    Posts
    28

    Re: Report showing Bundle Version

    Heres a little SQL Script that will give you a summary. I'm sure you could easily modify it for a full device list.

    SELECT SUBSTRING(ZenAgentVersion,CHARINDEX('<Version>', ZenAgentVersion)+9,8) as VERSIONNO, COUNT(ZUID) AS COUNTOFDEVICES
    FROM zDevice
    group by SUBSTRING(ZenAgentVersion,CHARINDEX('<Version>', ZenAgentVersion)+9,8)

  6. #6
    Join Date
    Apr 2009
    Location
    South Coast, England
    Posts
    28

    Re: Report showing Bundle Version

    I'm no database guy either and this one is untested but should give you a zdevice table + the Agent Version.

    SELECT *, SUBSTRING(ZenAgentVersion,CHARINDEX('<Version>', ZenAgentVersion)+9,8) as VERSIONNO
    FROM zDevice

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •