Hi John,
Quick question, In the last one you helped me with, the report SQL had the
custom registry values starting with "chi64.Chico_AssetTag0 as [Reg Asset 64]",
etc. I'm creating another report using your SQL, but it's for a different
registry value. The RegKeytoMOF text is below. I'm attaching the MOF for the
one we worked on, as well as the query you came up with. What would the Oracle
values be in the SQL? ora.ORACLE_inst_loc0 and ora.ORACLE_inst_NLS_LANG 0?
Thanks!
Mike
// RegKeyToMOF by Mark Cochrane (thanks to Skissinger, Steverac, Jonas Hettich
& Kent Agerlund)
// this section tells the inventory agent what to collect
// 8/27/2014 1:00:18 PM
#pragma namespace ("\\\\.\\root\\cimv2")
#pragma deleteclass("ORACLE", NOFAIL)
[DYNPROPS]
Class ORACLE
{
[key] string KeyName;
String inst_loc;
String NLS_LANG;
};
[DYNPROPS]
Instance of ORACLE
{
KeyName="RegKeyToMOF_32";
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ORACLE|inst_loc"),Dynamic,Provider("RegPropProv")]
inst_loc;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ORACLE|NLS_LANG"),Dynamic,Provider("RegPropProv")]
NLS_LANG;
};
#pragma namespace ("\\\\.\\root\\cimv2")
#pragma deleteclass("ORACLE_64", NOFAIL)
[DYNPROPS]
Class ORACLE_64
{
[key] string KeyName;
String inst_loc;
String NLS_LANG;
};
[DYNPROPS]
Instance of ORACLE_64
{
KeyName="RegKeyToMOF_64";
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ORACLE|inst_loc"),Dynamic,Provider("RegPropProv")]
inst_loc;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ORACLE|NLS_LANG"),Dynamic,Provider("RegPropProv")]
NLS_LANG;
};
// RegKeyToMOF by Mark Cochrane (thanks to Skissinger, Steverac, Jonas Hettich
& Kent Agerlund)
// this section tells the inventory agent what to collect
// 5/21/2014 1:29:43 PM
#pragma namespace ("\\\\.\\root\\cimv2")
#pragma deleteclass("Chico", NOFAIL)
[DYNPROPS]
Class Chico
{
[key] string KeyName;
String OSD_Base;
String OSD_Core;
String Chico_AssetTag;
String Chico_BusinessArea;
String Chico_BuildingCode;
String Chico_RoomCode;
String Roles;
String Role_Admin;
String OSD_Deploy;
};
[DYNPROPS]
Instance of Chico
{
KeyName="RegKeyToMOF_32";
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Chico|OSD-Base"),Dynamic,Provider("RegPropProv")]
OSD_Base;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Chico|OSD-Core"),Dynamic,Provider("RegPropProv")]
OSD_Core;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Chico|Chico_AssetTag"),Dynamic,Provider("RegPropProv")]
Chico_AssetTag;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Chico|Chico_BusinessArea"),Dynamic,Provider("RegPropProv")]
Chico_BusinessArea;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Chico|Chico_BuildingCode"),Dynamic,Provider("RegPropProv")]
Chico_BuildingCode;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Chico|Chico_RoomCode"),Dynamic,Provider("RegPropProv")]
Chico_RoomCode;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Chico|Roles"),Dynamic,Provider("RegPropProv")]
Roles;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Chico|Role_Admin"),Dynamic,Provider("RegPropProv")]
Role_Admin;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Chico|OSD-Deploy"),Dynamic,Provider("RegPropProv")]
OSD_Deploy;
};
#pragma namespace ("\\\\.\\root\\cimv2")
#pragma deleteclass("Chico_64", NOFAIL)
[DYNPROPS]
Class Chico_64
{
[key] string KeyName;
String OSD_Base;
String OSD_Core;
String Chico_AssetTag;
String Chico_BusinessArea;
String Chico_BuildingCode;
String Chico_RoomCode;
String Roles;
String Role_Admin;
String OSD_Deploy;
};
[DYNPROPS]
Instance of Chico_64
{
KeyName="RegKeyToMOF_64";
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Chico|OSD-Base"),Dynamic,Provider("RegPropProv")]
OSD_Base;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Chico|OSD-Core"),Dynamic,Provider("RegPropProv")]
OSD_Core;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Chico|Chico_AssetTag"),Dynamic,Provider("RegPropProv")]
Chico_AssetTag;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Chico|Chico_BusinessArea"),Dynamic,Provider("RegPropProv")]
Chico_BusinessArea;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Chico|Chico_BuildingCode"),Dynamic,Provider("RegPropProv")]
Chico_BuildingCode;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Chico|Chico_RoomCode"),Dynamic,Provider("RegPropProv")]
Chico_RoomCode;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Chico|Roles"),Dynamic,Provider("RegPropProv")]
Roles;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Chico|Role_Admin"),Dynamic,Provider("RegPropProv")]
Role_Admin;
[PropertyContext("Local|HKEY_LOCAL_MACHINE\\SOFTWARE\\Chico|OSD-Deploy"),Dynamic,Provider("RegPropProv")]
OSD_Deploy;
};
Select Distinct
sys1.Netbios_Name0 AS [Computer Name],
sys1.user_name0 AS [User Name],
sys1.Resource_Domain_OR_Workgr0 AS [Domain/Workgroup],
[Top Console User] = CASE
when (tusr.TopConsoleUser0 is NULL or tusr.TopConsoleUser0 = '-1')
then 'Unknown'
Else tusr.TopConsoleUser0
End,
os.Caption0 AS [OS Edition],
os.CSDVersion0 AS [Service Pack],
enc.SMBIOSAssetTag0 AS [Asset Tag],
CONVERT(VARCHAR(26), bios.ReleaseDate0, 101) AS [BIOS Date],
cs.Manufacturer0 AS [Manufacturer],
cs.Model0 as [Model],
cpu.NormSpeed0 as [CPU Speed],
mem.TotalPhysicalMemory0 as [Total RAM],
dsk.Size0 as [Disk Size],
dsk.FreeSpace0 as [Free Space],
/*chi.Chico_AssetTag0 as [Reg Asset],
chi.Chico_BuildingCode0 as [Building],
chi.Chico_RoomCode0 as [Room],
chi.Chico_BusinessArea0 as [Bus Area],
chi.OSD_Base0 as [OSD Base],
chi.OSD_Deploy0 as [OSD Deploy],
chi.Role_Admin0 as [Role Admin],
chi.Roles0 as [Roles],
*/
chi64.Chico_AssetTag0 as [Reg Asset 64],
chi64.Chico_BuildingCode0 as [Building 64],
chi64.Chico_RoomCode0 as [Room 64],
chi64.Chico_BusinessArea0 as [Bus Area 64],
CONVERT(VARCHAR(26), chi64.OSD_Base0, 101) AS [OSD Base 64],
CONVERT(VARCHAR(26), chi64.OSD_Deploy0, 101) AS [OSD Deploy 64],
chi64.Role_Admin0 as [Role Admin 64],
chi64.Roles0 as [Roles 64]
from v_R_System_Valid sys1
LEFT JOIN v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP tusr on tusr.ResourceID =
sys1.ResourceID
INNER JOIN v_GS_OPERATING_SYSTEM os on os.ResourceID = sys1.ResourceID
INNER JOIN v_GS_SYSTEM_ENCLOSURE_UNIQUE enc on enc.ResourceID = sys1.ResourceID
INNER JOIN v_GS_PC_BIOS bios on bios.ResourceID = sys1.ResourceID
INNER JOIN v_GS_COMPUTER_SYSTEM cs on cs.ResourceID = sys1.ResourceID
INNER JOIN v_GS_X86_PC_MEMORY mem on mem.ResourceID = sys1.ResourceID
INNER JOIN v_GS_PROCESSOR cpu on cpu.ResourceID = sys1.ResourceID
LEFT JOIN V_GS_Chico0 chi on chi.resourceID = sys1.ResourceID
LEFT JOIN V_GS_Chico640 chi64 on chi64.resourceID = sys1.ResourceID
INNER JOIN v_FullCollectionMembership fcm on fcm.ResourceID = sys1.ResourceID
INNER JOIN v_GS_LOGICAL_DISK dsk on dsk.ResourceID = sys1.ResourceID
Where fcm.CollectionID = @CollID and dsk.DeviceID0 = 'C:'
order by sys1.Netbios_Name0
