(imported comment written by Darknight)
Hi Brian … thanks for the help … i recitfied that expression and got the result , but waht i want to achive is to combine all the below mentioned relevance in a one property to have results as mention below :
expected result :
A:
GenuineIntel | 6 | | False | 9 | Xeon | Ok | 3 | 4
GenuineIntel | 6 | | False | 9 | Xeon | Ok | 3 | 4
the separate properties are as shown below:
q:
/Manufacturer Name - Processor/
(
if
(name
of
operating system
as
lowercase
contains
“sun”
)
then
(
""
)
else
if
(
exists
dmi)
then
( processor_manufacturers
of
processor_informations
of
dmi
as
string)
else
(
""
))
whose
(
it
does not contain
“0”
)
A:
GenuineIntel
A:
GenuineIntel
T:
0.200 ms
q:
/Level_Processor/
if
(windows
of
operating system)
then
(
if
exists
(string values
of
selects
“Level from Win32_Processor”
of
wmi)
then
(string values
of
selects
“Level from Win32_Processor”
of
wmi)
else
(
""
))
else
(
""
)
A:
6
A:
6
T:
14.112 ms
q:
/PNPDeviceID_Processor/
if
(unix
of
operating system)
then
(
""
)
else
if
(windows
of
operating system)
then
(
if
exists
(string values
of
selects
“PNPDeviceID from win32_Processor”
of
wmi)
then
(string values
of
selects
“PNPDeviceID from win32_Processor”
of
wmi)
else
(
""
))
else
(
""
)
A:
T:
7.996 ms
q:
/PowerManagementSupported_Processor/
if
(unix
of
operating system)
then
(
""
)
else
if
(windows
of
operating system)
then
(
if
exists
(string values
of
selects
“PowerManagementSupported from win32_Processor”
of
wmi)
then
(string values
of
selects
“PowerManagementSupported from win32_Processor”
of
wmi)
else
(
""
))
else
(
""
)
A:
False
A:
False
T:
15.347 ms
q:
/ProcessorArchitecture_Processor/
if
(name
of
operating system
as
lowercase
contains
“sun”
)
then
(types
of
processors
as
string)
else
if
(name
of
operating system
as
lowercase
contains
“linux”
)
then
(parenthesized parts
1
of
(matches (regex
“ProcessorArchitecture=(.+)”
)
of
it
)
of
lines
whose
(
it
contains
“ProcessorArchitecture=”
)
of
file
“inventory.txt”
of
folder
“__HardwareInfo”
of
client folder
of
site
whose
(name
of
it
starts with
“actionsite”
))
else
if
(windows
of
operating system)
then
(
if
exists
(string values
of
selects
“Architecture from win32_Processor”
of
wmi)
then
(string values
of
selects
“Architecture from win32_Processor”
of
wmi)
else
(
""
))
else
(
""
)
A:
9
A:
9
T:
14.747 ms
q:
/ProcessorFamily_Processor/
family names
of
processors
A:
Xeon
A:
Xeon
T:
0.043 ms
q:
/ProcessorStatus_Processor/
if
(name
of
operating system
as
lowercase
contains
“sun”
)
then
(states
of
processors
as
string)
else
if
(name
of
operating system
as
lowercase
contains
“linux”
)
then
(
if
(
exists
dmi)
then
(unique values
of
statuss
of
processor_informations
of
dmi
as
string)
else
(
""
))
else
if
(windows
of
operating system)
then
(
if
exists
(string values
of
selects
“Status from win32_Processor”
of
wmi)
then
(string values
of
selects
“Status from win32_Processor”
of
wmi
as
string)
else
(
""
))
else
(
""
)
A:
OK
A:
OK
T:
14.746 ms
q:
/ProcessorType_Processor/
if
(name
of
operating system
as
lowercase
contains
“sun”
)
then
(type
of
processor
as
string)
else
if
(name
of
operating system
as
lowercase
contains
“linux”
)
then
(parenthesized parts
1
of
(matches (regex
“Processor_Type:(.+)”
)
of
it
)
of
lines
whose
(
it
contains
“Processor_Type:”
)
of
file
“inventory.txt”
of
folder
“__HardwareInfo”
of
client folder
of
site
whose
(name
of
it
starts with
“actionsite”
))
else
if
(windows
of
operating system)
then
(
if
(
exist
(string values
of
selects
“ProcessorType from win32_Processor”
of
wmi))
then
(string values
of
selects
“ProcessorType from win32_Processor”
of
wmi)
else
(
""
))
else
(
""
)
A:
3
A:
3
T:
14.999 ms
q:
/UpgradeMethod_Processor/
if
(unix
of
operating system)
then
(
if
(
exists
dmi)
then
(unique values
of
processor_upgrades
of
processor_informations
of
dmi
as
string)
else
(
“N/A”
))
else
if
(windows
of
operating system)
then
(
if
(
exists
(string values
of
selects
“UpgradeMethod from Win32_Processor”
of
wmi))
then
(string values
of
selects
“UpgradeMethod from Win32_Processor”
of
wmi)
else
(
""
))
else
(
""
)
A:
4
A:
4
T:
17.759 ms
as menioned in my previous post i can combine the individual relevance if the are getting evaluated by single method that is either by wmi or by dmi or purely through relevance , but in the above case its the mixture of all and i am bit confused how i can combine thses results in a single relevance clause and get the desired output.
Please assist me.