Custom Inventory Script not displaying correct information
Hi,
I have two custom invetory rules to check on the Bilocker Status of a machine (one for 32 and one for 64bit machines)
ShellCommandTextReturn(C:\Windows\System32\manage-bde.exe -status c:) - 32 bit
ShellCommandTextReturn(%windir%\sysnative\manage-bde.exe -status c:) - 64 bit
These work fine on English machines and the KACE inventory for the machine shows something along the lines of:
BitLocker Drive Encryption: Configuration Tool version 6.1.7600
Copyright (C) Microsoft Corporation. All rights reserved.
Volume C: []
[OS Volume]
Size: 148.95 GB
BitLocker Version: Windows 7
Conversion Status: Fully Encrypted
Percentage Encrypted: 100%
Encryption Method: AES 128 with Diffuser
Protection Status: Protection On
Lock Status: Unlocked
Identification Field: None
Key Protectors:
TPM
Numerical Password
[string]
but on foreign machines (for example German) the text is truncated to the first foreign character (in this case it is a ü)
The kdeploy.log on the machine shows the below information:
[Tue Sep 04 13:04:13 2012] KDeploy Item 16964: Results=True Raw=';16964:BitLocker-LaufwerkverschlÂsselung: Konfigurationstoolversion 6.1.7601
Copyright (C) Microsoft Corporation. Alle Rechte vorbehalten.
Volume "C:" [System]
[Betriebssystemvolume]
GrӇe: 297,99 GB
BitLocker-Version: Windows 7
Konvertierungsstatus: Vollst„ndig verschlÂsselt
VerschlÂsselt (Prozent): 100 %
VerschlÂsselungsmethode: AES 128 mit Diffuser
Schutzstatus: Der Schutz ist aktiviert.
Sperrungsstatus: Entsperrt
ID-Feld: Kein
SchlÂsselschutzvorrichtungen:
Externer SchlÂssel
Numerisches Kennwort
TPM und PIN
But in the KACE admin console it is truncated to BitLocker-Laufwerkverschl [string]
So it appears to be getting stuck when it gets to this work Laufwerksverschl(here)üsselung
Does anyone have any ideas on how to get around this?
Answers (2)
I would submit this to techinical support. It may be a bug in either the display or the database. Try creating a report that includes the custom field and see if it displays correctly there. Even better, if you have a tool like MySQL Workbench you can see what data is actually uploaded to the database.
Comments:
-
It doesn't display in a report for the custom field either, I do have MySQL Workbench but unfortunately I don't have a clue how to use it
I have submitted it to technical support but they seem to take days to get back to me - martynryan1 12 years ago -
Have you configured MySQL Workbench to connect to your KBOX? It should be as simple as entering your KBOX hostname and the username and password that are setup in Settings, Control Panel, General Settings (also be sure the enable DB Access in Settings, Control Panel, Security Settings).
Once that is setup, browse the ORG1 tables (assuming you only have one organization) and view the data for MACHINE_CUSTOM_INVENTORY. You'll need to know the ID for the custom inventory rule you created (visible in the URL if you're using adminui) and that will help you find it in the table. For instance, if the ID for your custom inventory rule is ID 23087 the following query would show the results for all computers that have that field:
SELECT * FROM ORG1.MACHINE_CUSTOM_INVENTORY WHERE SOFTWARE_ID = 23087
Alternatively you can search for a specific machine using the ID field:
SELECT * FROM ORG1.MACHINE_CUSTOM_INVENTORY WHERE ID = 28
This will show all of the custom inventory fields for machine with ID 28. - chucksteel 12 years ago -
Thanks for that. If I query:
SELECT * FROM ORG1.MACHINE_CUSTOM_INVENTORY WHERE ID = 483
483 is a German Machine
Then i get STR_FIELD_VALUE = BitLocker-Laufwerkverschl and that is all so it looks like it hasn't uploaded the full information from the ShellCommandTextReturn to the database
I logged a call with KACE support but so far I have just been given an International License to try instead of the English only one that we had but this has made no difference - martynryan1 12 years ago
