If you provide me with what you have so far and a screenshot of what your looking at I will be able to provide you with exactly what your looking for. This will saving me having to guess and being off the mark of what your trying to do.
Hi Rob, the info available isn't really exposed in standard reports unless Martin has access to something that has already been done.
What you can do though is export it so that you can filter out the stuff you want and produce something in Excel. You could also go directly to the 'PatchHistory' table in SQL and parse the data from there.
There's also our State management plugin that could do this too if you can't/don't want to go down the other paths.
MarXtar Ltd/MarXtar Corporation
LANDESK One Development Partner
The One-Stop Shop for LANDESK Enhancements
I have this so far:
As we place all our workstations into their own respective OU's I can target this and then create a report on each branch.
What I need to do is somehow limit the query to the last day or even week.
Currently the query brings back all logon events for the workstation in the database.
Hope this makes sense.
So I have a SQL query that can extract the data I want from the database and also just for today but how do I put that into the report designer and target it against the computer location.
Are there any step by step guides on using the report designer advanced feature?
Brilliant , if you have the SQL query to extract the information then you can use this with the report. The current guide to do this is 500 pages long so to save you time i have created this series of screenshots of what to do :
1. Create a new report under Reporting/Monitoring > Reports , Right click in My reports , Click 'New Reports'
2. In the new report goto the report designer:
3. In the report designer under 'Data Sources' right click on LDMS and click on 'Add Data Set'
4. Enter your query under 'Query' Making sure that you add the 'as' variable for the fields you want to show. (I have used a pre-filled example to help show what I mean further)
5. Add these fields under 'Field' And give them variable names, this will be used in the main report designer window:
6. Accept once you have finished with these changes, to commit them to the report:
7. Create your table by clicking on he down arrow in the toolbox until you see the table option and then drag and drop it into the main area:
9. Give your table headings, as exampled above and then select the variable for the boxes like below, the option you will be shown will be the fields that you created before:
10. Once finished save and test report.
Thanks Martin. Very helpful.
I will give this a try and see how I get on.