Howdy Everyone,

I am trying to get a report of all the computers in our system that have older versions of .NET. I am using the report wizard to do this. 3.5 sp1 and newer are fine and I'm trying to filter these out. I am using the computer group and from there using software titles to check for the .NET patches. I can get it to eliminate the patches 3.5 sp1 and newer but it doesn't remove the computers from the search it shows the computers with out showing 3.5 sp1 or newer in the software box. I am going crazy on how to figure our what order I should put these in to get the right info. Would this have to be done by SQL or can I do it with the report wizard?

Thanks
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

1
Hey hermant,

This report will list all machines that have a lower .net < 3.5.
SELECT
M.NAME, S.DISPLAY_NAME
FROM
MACHINE M,
SOFTWARE S,
MACHINE_SOFTWARE_JT MS
WHERE
M.ID = MS.MACHINE_ID
AND MS.SOFTWARE_ID = S.ID
AND S.DISPLAY_NAME LIKE '%NET FRAMEWO%'
AND S.DISPLAY_NAME NOT RLIKE 'FRAMEWORK (3\.5|[4-9])'
AND S.IS_PATCH = 0
ORDER BY M.NAME, S.DISPLAY_NAME

That report shows computers though even if they have a newer and older version of .net.

To remove if it has newer try this:
SELECT
M. NAME,
S.DISPLAY_NAME
FROM
MACHINE M,
SOFTWARE S,
MACHINE_SOFTWARE_JT MS
WHERE
M.ID = MS.MACHINE_ID
AND MS.SOFTWARE_ID = S.ID
AND S.DISPLAY_NAME LIKE '%NET FRAMEWO%'
AND S.DISPLAY_NAME NOT RLIKE 'FRAMEWORK (3\.5|[4-9])'
AND S.IS_PATCH = 0
AND M.ID NOT IN (
SELECT DISTINCT
M.ID
FROM
MACHINE M,
SOFTWARE S,
MACHINE_SOFTWARE_JT MS
WHERE
M.ID = MS.MACHINE_ID
AND MS.SOFTWARE_ID = S.ID
AND S.DISPLAY_NAME RLIKE 'FRAMEWORK (3\.5|[4-9])'
AND S.IS_PATCH = 0
)
ORDER BY
M. NAME,
S.DISPLAY_NAME
Answered 03/07/2012 by: dchristian
Red Belt

Please log in to comment
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
Thanks David,

That did just what I needed. You are awesome.

Teddy
Answered 03/07/2012 by: hermant
Yellow Belt

Please log in to comment
Answer this question or Comment on this question for clarity