Jump to content


  • 0
wmmayms

Simple Report showing all computer who has a failed advertisement

Question

This report shows all clients which have a advertisement which failed.

It is also linked to report 108 (“Advertisement status messages for a particular client and advertisement”) meaning that you can access this report by clicking the link in the first column.

 

This is how it could look:

post-2500-1237809483_thumb.jpg

 

To create this report follow these instructions:

1. Open SMS Console

2. Expand the reporting node

3. Rightclick reports --> New --> Report

4. Enter a name (for example: "All Clients which has a failed advertisement")

5. Enter a category

6. Enter a description

7. Choose "Edit SQL Statement"

 

Insert this code:

SELECT 
a.Name0, 
b.AdvertisementID, 
c.AdvertisementName,
b.LastStateName,
d.Name,
c.ProgramName

FROM
v_R_System a, 
v_ClientAdvertisementStatus b,
v_Advertisement c,
v_Package d

WHERE a.ResourceID = b.ResourceID
AND b.AdvertisementID = c.AdvertisementID
AND c.PackageID = d.PackageID
AND b.LastStateName = 'failed'

 

8. Press OK

9. Choose the tab "Links"

10. Configure according to this picture (reportID: 108)

post-2500-1237809765_thumb.jpg

 

11. Press OK

12. Rightclick on your report. Choose All tasks --> Run --> <SMSREPORTINGPOINT>

 

You are all done.

Share this post


Link to post
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.