- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-01-2012 12:57 AM
I have the registry scanning options set and this is working well. The problem becomes in reporting as all three valuenames are the same "LastSuccessTime"
The report is generating and giving me three lines for each PC
pc1 detect date
pc1 download date
pc1 install date
pc2 detect date
pc2 download date
pc2 install date
pc3 detect date
pc3 download date
pc3 install date
Ideally, I would like to have
Detect Download Install
PC1 date date date
PC2 date date date
PC3 date date date
PC4 date date date
From the report builder, here's the code:
Select Top 1000000 tblRegistry.Valuename, tblRegistry.Value,
tblRegistry.Computername, tblComputers.LastknownIP, tblComputers.Computer,
tblComputers.Username, tblADusers.Firstname, tblADusers.Lastname,
tblRegistry.Regkey
From tblRegistry Inner Join
tblComputers On tblComputers.Computername = tblRegistry.Computername
Inner Join
tblADusers On tblADusers.Username = tblComputers.Username
any help / thoughts would be greatly appreciated.
Solved! Go to Solution.
- Labels:
-
Report Center
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-17-2017 03:17 PM
Select tblAssets.AssetName,
tblAssets.AssetUnique,
tblAssets.Domain,
tblADusers.Firstname,
tblADusers.Lastname,
FirstKey.Detect,
SecondKey.Download,
ThirdKey.Install
From tblAssets
Left Join (Select tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Value As Download
From tblRegistry
Where
tblRegistry.Regkey =
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Download') SecondKey On SecondKey.AssetID = tblAssets.AssetID
Left Join (Select tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Value As Install
From tblRegistry
Where
tblRegistry.Regkey =
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Install') ThirdKey On ThirdKey.AssetID = tblAssets.AssetID
Left Join (Select tblRegistry.AssetID,
tblRegistry.Regkey,
tblRegistry.Value As Detect
From tblRegistry
Where
tblRegistry.Regkey =
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Detect') FirstKey On FirstKey.AssetID = tblAssets.AssetID
Left Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Order By tblAssets.AssetUnique
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-25-2012 01:53 PM
The line break problem in the forum thread linked by wcb had a different cause. Report code used to be squeezed into the left pane at the bottom of the report builder, on the left side of the divider. A change was then made so that any code automatically crossed this divider.
The problem now appears to be that the configuration console window itself is introducing unwanted line breaks. If you're viewing the configuration console at a small size and have a bigger screen, maximize the console for now to avoid this issue. The problem only occurs when pasting the code, not when compiling the same report directly in the report builder.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-24-2012 11:05 PM
-Sal
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-24-2012 09:43 PM
I was looking for some other information about the report builder and came across this post:
http://www.lansweeper.com/forum/yaf_postst5381_Report-Builder-corrupt-SQL-query.aspx
Someone else had this wordwrap problem last year. It says they were going to address the issue with an update so maybe it works better than it used to but still has some of the issue?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-24-2012 07:31 PM
If you get the code window to keep the strings inside the quotes on one line when you click save, then it seems your report will save OK for the website. Otherwise it saves with incorrect spacing in the string value.
I am attaching screen shots to try to show what I am talking about.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-24-2012 06:11 PM
The lansweeper report builder auto formats the SQL code and it inserts a line break when the line is too long. It is inserting a line break in between the words Auto and Update in the first two conditions of the where clause. Interestingly, it leaves the last line alone and does not insert a line break.
Now comes a more interesting part. I changed the default size of the window by dragging the divider between the report definition and the list of reports to the left. This gives more room for the report definition. I added a carriage return or two manually to get the Regkey strings on lines by themselves. Now there is no return inserted between Auto and Update and I get results.
Sadly, I could not get the layout to stick and could not save the report without the errant line break. Hopefully this will allow Lansweeper to update the auto format of the code window and eventually this will work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-24-2012 04:25 PM
i'm very interested in this report too, so i tried it on our server. but i'm getting the same error as described: the report fields are empty.
does anyone have a solution for the "empty report" yet?
thx & cheers,
frank
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-03-2012 11:41 PM
I had to take it out and put it into a text editor and make all the "(Select...) Left Join" lines run on 1 line each and then paste it into the report builder.
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblADusers.Firstname, tblADusers.Lastname,
FirstKey.Detect, SecondKey.Download, ThirdKey.Install
From tblComputers Left Join
(Select tblRegistry.Computername, tblRegistry.Regkey, tblRegistry.Value As
Download
From tblRegistry
Where
tblRegistry.Regkey =
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Download') SecondKey On SecondKey.Computername = tblComputers.Computername Left Join
(Select tblRegistry.Computername, tblRegistry.Regkey, tblRegistry.Value As
Install
From tblRegistry
Where
tblRegistry.Regkey =
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Install') ThirdKey On ThirdKey.Computername = tblComputers.Computername Left Join
(Select tblRegistry.Computername, tblRegistry.Regkey, tblRegistry.Value As
Detect
From tblRegistry
Where
tblRegistry.Regkey =
'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\Results\Detect') FirstKey On FirstKey.Computername = tblComputers.Computername Left Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain
Order By tblComputers.ComputerUnique
-Sal
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-06-2012 04:22 AM
I'm going to get with a SQL person either Monday or tuesday to see what i'm doing wrong.
i've copied / pasted and tried aligning.
thanks so much
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-16-2012 08:08 PM
The format is exactly what we need but the fields are blank.
I'm still searching for a SQL person to check out the copy / paste issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-03-2012 06:46 PM
Do I need to include the tblRegistry ?