Up to Discussions in Inventory

This Question is Answered

1 "helpful" answer available (10 pts)
6 Replies Last post: Nov 20, 2008 12:59 PM by Wintermute  
Grafzahl Rookie
Grafzahl
7 posts since
Aug 25, 2008
Currently Being Moderated

Nov 19, 2008 12:06 AM

Query is missing custom data fields

Hello,

 

we scan our clients for a specific registry key. This works good. When I look at the inventory of the clients I can see the key and its value.

But trying to create a query on this key fails. In the query window I cannot see this Custom Field. The Custom Data field is double and it contains only one value. But no Internet Explorer, no MDAC and not my custom field.

I want it back! Any ideas?

 

Thanks

 

Grafzahl

Tags: query, custom_data, missing
Jilufe Apprentice
Jilufe
29 posts since
Jan 7, 2008
Currently Being Moderated
1. Nov 19, 2008 2:19 AM in response to: Grafzahl
Re: Query is missing custom data fields

Could you attach the ldappl3.ini? It resides in \\core\ldlogon folder

Thanks

Report Abuse
ahe Expert
ahe
573 posts since
Dec 21, 2007
Currently Being Moderated
2. Nov 19, 2008 2:24 AM in response to: Grafzahl
Re: Query is missing custom data fields

Hello,

 

it could be that your database has corrupt entries which "blocks" the correct one for query creation.

 

Try to check and repair the Custom Data entries with DBREPAIR:Database Repair Utility

 

s. threads:

http://community.landesk.com/support/message/8783#8783

http://community.landesk.com/support/docs/DOC-2297#comment-1083

 

 

Regards

Axel

Report Abuse
Grafzahl Rookie
Grafzahl
7 posts since
Aug 25, 2008
Currently Being Moderated
3. Nov 19, 2008 5:43 AM in response to: ahe
Re: Query is missing custom data fields

Hello,

 

the database repair solved our problem.

 

Thanks Axel.

 

Greetings

 

Grafzahl

Report Abuse
Paul Hoffmann Master
Paul Hoffmann
1,803 posts since
Dec 11, 2007
Currently Being Moderated
4. Nov 19, 2008 7:13 AM in response to: Grafzahl
Re: Query is missing custom data fields

Please make sure you've done a COREDBUTIL -> BUILD COMPONENTS after running DBREPAIR (and please make sure your Inventory Service is stopped during this - can't stress this enough) - so that all the data is correctly linked together again.

 

Paul Hoffmann

LANDesk EMEA Technical Lead

Report Abuse
ahe Expert
ahe
573 posts since
Dec 21, 2007
Currently Being Moderated
5. Nov 19, 2008 7:24 AM in response to: Paul Hoffmann
Re: Query is missing custom data fields

Hello Paul,

 

it would be nice to have a automatic task to do this...deactivate inventory service, cleanup with dbrepair, start coredbutil, activate inventory service.

But I fear I need a external tool for this... (like DatabaseDoctor...)

 

We've to do this every week for all cores and the roll-up. Some cores are cleaned in some seconds, some need half an hour (the roll-up cleaning need much more time). It's a strange task and I can't find the clients which are involved...

 

Regards

Axel

Report Abuse
Wintermute Apprentice
Wintermute
76 posts since
Dec 18, 2007
Currently Being Moderated
6. Nov 20, 2008 12:59 PM in response to: ahe
Re: Query is missing custom data fields

You could automate the process via scripting, but we don't do that for the simple reason that DBRepair cleans out the Unmodeled data from your DB - this includes Custom Data that's being collected via the ldappl file, etc. Dbrepair is considered a 'use only when needed' tool.

Report Abuse

More Like This

  • Retrieving data ...
LANDesk Community powered by Jive Software's Clearspace ® Subscribe| Legal Notices| Investor Relations| Avocent| Privacy Policy © 2009 LANDesk Software