.NET older versions
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
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
Answers (2)
Please log in to answer
Posted by:
dchristian
12 years ago
Hey hermant,
This report will list all machines that have a lower .net < 3.5.
That report shows computers though even if they have a newer and older version of .net.
To remove if it has newer try this:
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_NAMEThat 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
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.