Two like reports, only one works....?

[lhawk]

Hi, eveyone.
I have entered two RegKey's to be scanned, that indicate the update version of our company's software package. I have two reports created to show which PC's have the update. The EpicSU808 report works great the EpicSU1108 doesn't return anything.

Like I said the EpicSU808 report works great. Does my problem with EpicSU1108 report have to do with the regkey's being so similar? I don't get it.. Thanks

Scanned reg keys:
EpicSU808
RegPath = HKLM\SOFTWARE\Epic Systems Corporation\75HotFix\7PRDINTEGRATE\{A4E56907-7BBF-44A9-BBC8-C32B067A4BCA}
RegValue = PatchGUID

EpicSU1108
RegPath = HKLM\SOFTWARE\Epic Systems Corporation\75HotFix\11PRDINTEGRAT\{A4E56907-7BBF-44A9-BBC8-C32B067A4BCA}
RegValue = PatchGUID


Report SQL query:
EpicSU808
SELECT
tblRegistry.Computername,
tblRegistry.Valuename,
tblRegistry.Value
FROM
tblRegistry
GROUP BY
tblRegistry.Computername,
tblRegistry.Valuename,
tblRegistry.Value
HAVING
tblRegistry.Valuename = 'PatchGUID' AND
tblRegistry.Value = '{C5643D98-943F-43D5-AAE7-49C8BF1E23E4}'

EpicSU1108
SELECT
tblRegistry.Computername,
tblRegistry.Valuename,
tblRegistry.Value
FROM
tblRegistry
GROUP BY
tblRegistry.Computername,
tblRegistry.Valuename,
tblRegistry.Value
HAVING
tblRegistry.Valuename = 'PatchGUID' AND
tblRegistry.Value = '{ED96A04C-58DA-48FB-A0B7-9EB4EFF82B87}'

[lhawk]

Thanks everyone for you reply's. It was user error. There was extra data in the second RegKey I was looking for. Once I fixed the syntax we were good. Thanks again.

[Hemoco]

Also make sure that you have set the second registry key to "enabled"

[Cobra7]

Check your tblRegistry and make sure there are some entries for the 2nd report to find.