Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-13-2015 10:48 PM
I'm trying to come up with a report that shows the last time windows updates were installed on a system. I've been messing around with the newest date for Quickfix but I cant seem to get a working report. Has anyone come up with a report that does this?
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-27-2015 02:18 PM
leblanc.daniel.4@hydro.qc.ca wrote:
I am also getting the same message of error, i am using SQL Express
There was an error parsing the query. [ Token line number = 1,Token line offset = 193,Token in error = Select ]
You are likely using SQL Compact, not SQL Express. These are two completely different database servers. We posted a SQL Compact compatible report in this topic a while back.
10 REPLIES 10
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-13-2015 11:14 PM
Try this:
Assumes that the entries in tblQuickFixEngineering are placed there as part of a Windows Update run, not one-off updates.
SELECT Top 1000000
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
( SELECT Top 1
tblQuickFixEngineering.Lastchanged
FROM
tblQuickFixEngineering
WHERE
tblQuickFixEngineering.AssetID = tblAssets.AssetID
ORDER BY
tblQuickFixEngineering.Lastchanged Desc) AS LastQFChange
FROM
tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
WHERE
tblAssetCustom.State = 1
Assumes that the entries in tblQuickFixEngineering are placed there as part of a Windows Update run, not one-off updates.
