Asset Management Suite

 View Only

How to Open a Contract Associated Document in a Report 

Nov 26, 2012 11:30 AM

I have been trying to work out how to open a Contract Associated Document in a report for a bit and I thought that others may be interested in how I did it.

In the end, I found it was easy:

1) Create a report that includes some SQL like this:

SELECT  [_ResourceGuid],

               [File]

FROM     [Inv_Associate_Documents]

2) Then, in the Drilldowns tab of the Report Builder, click, "Add" to add another Drilldown.

3) Next, Add a name for the Drilldown and select the Event (in my case, I used "Click").

4) In the "Performs" box, select "Open a URL in a New Window".

5) In the "Action Configuration" section, set the "Open URL:" to be {File}

6) In the Passing Parameters section, add a "Selected Data" field and add it as "File" and passed as "File".

7) Save and you are done!

All you do then is to run the report and select a File and (in my case) click the line and then a new browser window appears with the document!

Here is a picture of what I did. I hope that this helps someone else!

 

 

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

Dec 16, 2013 05:44 AM

Samir,

In the SMP/Altiris Console, go to the Reports menu and All Reports. In here, right-mouse-click upon a Reports leaf and select New->Report->SQL Report, as here:

Untitled_1.png

Next, add the SQL into the report like this:

Untitled_2.png

Give the report a name and click, "Save Changes" and you have a report.

Dec 16, 2013 12:44 AM

Hi QuietLeni,

                          I am new to Asset management now the first point which you have mentioned i.e create a SQL report which contains 
 

1) Create a report that includes some SQL like this:

SELECT  [_ResourceGuid],

               [File]

FROM     [Inv_Associate_Documents]

Where do i add this??? 

 

Dec 21, 2012 05:42 AM

alcer123,

It is not the permissions in Altiris (i.e. Security Roles and Accounts) that controls whether a user can see the resultant file in the report. It is the NT permissions on the FILE ITSELF and how you access the file.

So, if the file path is:

\\MYFILESERVER\DepartmentRestrictedShare\Invoice.pdf

or

I:\Invoices\Invoice.pdf (where I: is a personal or departmental share)

And the user is outside of the department, with no permissions to that share, then they will not be able to see the resultant file when they click upon it.

If the file path is:

\\COMPANYFILESERVER\EveryonesShare\Invoice.doc

Then, as long as you are on the company network and able to see the file, then the file will be accessable and will show.

If the file has a path of something like http://www.someunrestrictedwebsite.com/SharedToEveryone/Invoice.pdf

Then they will be able to see it wherever they are in the world (as long as the Internet is not down)! However, you may not want this.

Anyway, it is nothing to do with Altiris - all Altiris is telling the browser to do is open a new window and show whatever you give it as a URL.

Hope that this helps.

QuietLeni

Dec 19, 2012 06:50 PM

Interesting article, I have been working on something similar, Adding a picture (scanned receipt of a computer) to an asset so it can follow the asset when it moves to a new department. I have some questions though: If this report is sent to a person outside of the department (IT department for instance), can that person see the file? I am just thinking about security rights settings on that file. What if you email that report? Can that link be right clicked and download? Very interesting. I will continue working on this and hope I can test it, I think it has potential for other uses.

 

Related Entries and Links

No Related Resource entered.