ball_bwb

Absent Member.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2013-10-10
13:05
1712 views
Need to export all Bundles Attributes
We need the list and attributes of all our windows 7 bundles to process in another application.
The reporting server seems not to work.
So the only chance I see is to go directly into the ZCM Database.
I have searched already but found only the ZBUNDLE Table, which holds some of the information.
It is missing some information like the Administrator notes which I desperatly need.
So: is there a documentation for the database with it's tables and relations?
Does anybody know which tables I have to plunder to get my information?
Thomas
The reporting server seems not to work.
So the only chance I see is to go directly into the ZCM Database.
I have searched already but found only the ZBUNDLE Table, which holds some of the information.
It is missing some information like the Administrator notes which I desperatly need.
So: is there a documentation for the database with it's tables and relations?
Does anybody know which tables I have to plunder to get my information?
Thomas
10 Replies


Knowledge Partner
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2013-10-11
13:00
Ball bwb,
> We need the list and attributes of all our windows 7 bundles to process
> in another application.
Why not use zman be? Bundle Export?
--
Anders Gustafsson (NKP)
The Aaland Islands (N60 E20)
Have an idea for a product enhancement? Please visit:
http://www.novell.com/rms
> We need the list and attributes of all our windows 7 bundles to process
> in another application.
Why not use zman be? Bundle Export?
--
Anders Gustafsson (NKP)
The Aaland Islands (N60 E20)
Have an idea for a product enhancement? Please visit:
http://www.novell.com/rms
ball_bwb

Absent Member.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2013-10-14
13:12
I don't need the Bundle, but the List of all bundles with their attributes and relation to the corrosponding hardware group.
As far as I understand, zman only exports one bundle with it's actions and files, so it can be imported into another ZCM system.
I am not an administrator, so I can't try the commands. Our guys gave me read access to the ZCM Database though. The information has to be there and it's the only way I know to get to it.
In the future we need th get the whole Process automated. For this an database access is the best way.
Thomas
As far as I understand, zman only exports one bundle with it's actions and files, so it can be imported into another ZCM system.
I am not an administrator, so I can't try the commands. Our guys gave me read access to the ZCM Database though. The information has to be there and it's the only way I know to get to it.
In the future we need th get the whole Process automated. For this an database access is the best way.
Thomas


Knowledge Partner
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2013-10-14
17:41
Ball bwb,
> In the future we need th get the whole Process automated. For this an
> database access is the best way.
OK. Let me ask Novell
--
Anders Gustafsson (NKP)
The Aaland Islands (N60 E20)
Have an idea for a product enhancement? Please visit:
http://www.novell.com/rms
> In the future we need th get the whole Process automated. For this an
> database access is the best way.
OK. Let me ask Novell
--
Anders Gustafsson (NKP)
The Aaland Islands (N60 E20)
Have an idea for a product enhancement? Please visit:
http://www.novell.com/rms
spgsitsupport

Absent Member.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2015-09-22
14:35
AndersG;2288063 wrote:
OK. Let me ask Novell
It has been a very long conversation then...
gerdesj

Absent Member.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2015-09-23
09:16
A while back I posted a SQL query that covers a fair amount of the bundle schema in this forum. Search on my username. Note that my query gets all bundle versions and not just the last one but it's a start. Much of the detail is held in large XML blobs which you will need to parse, so zman may be your best bet anyway.
Cheers
Jon
Cheers
Jon
Anonymous_User

Absent Member.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2015-09-23
13:58
Spgsitsupport,
> It has been a very long conversation then...
I apparently never got a reply...
--
Anders Gustafsson (NKP)
The Aaland Islands (N60 E20)
Have an idea for a product enhancement? Please visit:
http://www.novell.com/rms
> It has been a very long conversation then...
I apparently never got a reply...
--
Anders Gustafsson (NKP)
The Aaland Islands (N60 E20)
Have an idea for a product enhancement? Please visit:
http://www.novell.com/rms
Anonymous_User

Absent Member.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2015-09-23
15:39
Anders,
to be fair, it would have been me that you asked: I guess I never got a
reply from engineering 🙂
--
Shaun Pond
in my "day job" I work for ENGL; our aim is to make Windows deployment
easy
to be fair, it would have been me that you asked: I guess I never got a
reply from engineering 🙂
--
Shaun Pond
in my "day job" I work for ENGL; our aim is to make Windows deployment
easy
de

Absent Member.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2015-09-24
06:37
[After writing this, I realized that the bulk of this thread is from 2013!]
I have a little process that I use to export all the XML files for all bundles, so we can search for certain things (for example, where we have used "setacl", or a given registry key.) Curiously, this is the only way I know to also get to the creation date.
If I understand what you're saying, maybe "ZMAN blas" might work. But I am not sure what you mean by bundle "attributes" beyond that. It is definitely worth getting the reporting server working for this, though as we're still on 11.2.4, I prefer to use the old Infoview server. The new reporting seems faster & able to handle a larger amount of data in less time. If it's not working for you, it could be as simple as them not giving you adequate rights. But I'd far rather do this as a report.
My biggest irk with doing this type of process with ZMAN is that "ZMAN bl" gives you a text list of bundles and folders that has to be massaged significantly to get a working list that you can feed into any other process; instead of showing the full name (e.g. folder-path\bundle-name) it creates text columns that you have to re-organize and edit to show just the full reference to the bundle names. I have macros to do the bulk of this editing, but it's by far the most time-consuming part of the process. I'd far prefer an output that showed the same information I have to provide to pull the bundle details.
Seems to me that all of this would be easier to do with the reporting server, though, and just export to Excel and maybe move around the columns to get what you need for a list ... or just list off the device assignments against bundles, which is a standard report. I'm still not as comfortable with the new reporting server as I am with the old Infoview, but even I can write a report that does that kind of data. It's going to be very similar to doing the kind of query you describe anyway, just a friendlier front end.
I have a little process that I use to export all the XML files for all bundles, so we can search for certain things (for example, where we have used "setacl", or a given registry key.) Curiously, this is the only way I know to also get to the creation date.
If I understand what you're saying, maybe "ZMAN blas" might work. But I am not sure what you mean by bundle "attributes" beyond that. It is definitely worth getting the reporting server working for this, though as we're still on 11.2.4, I prefer to use the old Infoview server. The new reporting seems faster & able to handle a larger amount of data in less time. If it's not working for you, it could be as simple as them not giving you adequate rights. But I'd far rather do this as a report.
My biggest irk with doing this type of process with ZMAN is that "ZMAN bl" gives you a text list of bundles and folders that has to be massaged significantly to get a working list that you can feed into any other process; instead of showing the full name (e.g. folder-path\bundle-name) it creates text columns that you have to re-organize and edit to show just the full reference to the bundle names. I have macros to do the bulk of this editing, but it's by far the most time-consuming part of the process. I'd far prefer an output that showed the same information I have to provide to pull the bundle details.
Seems to me that all of this would be easier to do with the reporting server, though, and just export to Excel and maybe move around the columns to get what you need for a list ... or just list off the device assignments against bundles, which is a standard report. I'm still not as comfortable with the new reporting server as I am with the old Infoview, but even I can write a report that does that kind of data. It's going to be very similar to doing the kind of query you describe anyway, just a friendlier front end.
Anonymous_User

Absent Member.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2015-09-24
13:05
Shaun Pond,
> to be fair, it would have been me that you asked: I guess I never got a
> reply from engineering 🙂
Yes. Did not check the date of the OP. 2 years ago... Yes, it is all
Shaun's fault 🙂
--
Anders Gustafsson (NKP)
The Aaland Islands (N60 E20)
Have an idea for a product enhancement? Please visit:
http://www.novell.com/rms
> to be fair, it would have been me that you asked: I guess I never got a
> reply from engineering 🙂
Yes. Did not check the date of the OP. 2 years ago... Yes, it is all
Shaun's fault 🙂
--
Anders Gustafsson (NKP)
The Aaland Islands (N60 E20)
Have an idea for a product enhancement? Please visit:
http://www.novell.com/rms
Anonymous_User

Absent Member.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2015-09-24
14:45
Anders,
...it usually is
--
Shaun Pond
in my "day job" I work for ENGL; our aim is to make Windows deployment
easy
...it usually is
--
Shaun Pond
in my "day job" I work for ENGL; our aim is to make Windows deployment
easy