Re: Report/Query for all advertisments of a specific user
- From: "Lars Norman Søndergaard" <lns@xxxxxxxxxxxxx>
- Date: Thu, 9 Jun 2005 17:10:22 +0200
Ramon,
As I see it: the resourceID you get from V_ClientAdvertisementStatus is the
resourceID of the machine where the advertisement ran. If you join
v_r_system rather than v_r_User and examine v_r_system.UserName / UserDomain
you get something that is somewhat usefull (since the v_r_system are
populated by the discovery process). I would assume that if you as part of
the advertisement also run a Discovery Data Collection Cycle.
Hope this makes sense (I realize that the first mail was less than 100%
clear).
Thanks
Lars Norman Søndergaard.
"Kroese, Ramon" <Ramon_point_Kroese@xxxxxx> skrev i en meddelelse
news:u0QcHUObFHA.1404@xxxxxxxxxxxxxxxxxxxxxxx
> Dear Lars,
>
> Most of our advertisments go against users. I can't find a table (or
> table's) in the query builder that contains both the AdvertismentID and
> the ResourceID of the user. With these value's I can create a Join and
> retrieve the information I want. From the SMS administrator console it is
> posible to see the advertisements of a user but I want to create a report
> for it.
>
> Ramon
>
> "Lars Norman Søndergaard" <lns@xxxxxxxxxxxxx> wrote in message
> news:uq5GrK2aFHA.2128@xxxxxxxxxxxxxxxxxxxxxxx
>> Hi Ramon,
>>
>> Your problem is probably that your advertisements go against machines and
>> not users. So you will have to rely on last logged on user. That way you
>> can join users to machines.
>>
>> Thanks
>> Lars Norman Søndergaard
>> "Kroese, Ramon" <Ramon_point_Kroese@xxxxxx> skrev i en meddelelse
>> news:Oo5Ok21aFHA.3016@xxxxxxxxxxxxxxxxxxxxxxx
>>> Hi All,
>>>
>>> I want to create a query to find all the advertisements a specific user
>>> gets offered.
>>>
>>> I have cloned the report 'All advertisements for a specific computer'
>>> and changed the prompt and the query into:
>>>
>>> SELECT adv.AdvertisementName,
>>> stat.LastStateName,
>>> adv.Comment AS C072,
>>> pkg.Name AS C062,
>>> adv.ProgramName AS C071,
>>> adv.SourceSite,
>>> adv.AdvertisementID
>>> FROM v_Advertisement adv
>>> JOIN v_Package pkg ON adv.PackageID = pkg.PackageID
>>> JOIN v_ClientAdvertisementStatus stat ON stat.AdvertisementID =
>>> adv.AdvertisementID
>>> JOIN v_R_User Usr ON stat.ResourceID=Usr.ResourceID
>>> WHERE Usr.User_Name0=@UserName
>>>
>>>
>>> The problem is that the ResourceID from the view
>>> 'v_ClientAdvertisementStatus' is NOT the ResourceID of the user. With
>>> the CollectionID from the view 'v_Advertisement' it is possible to
>>> retrieve the collection. Is it posible to retrieve the CollectionID's or
>>> AdvertisementID's from a user so I can create a join?
>>>
>>> Thanks in advance,
>>>
>>> Ramon Kroese
>>>
>>
>>
>
>
.
- References:
- Report/Query for all advertisments of a specific user
- From: Kroese, Ramon
- Re: Report/Query for all advertisments of a specific user
- From: Lars Norman Søndergaard
- Re: Report/Query for all advertisments of a specific user
- From: Kroese, Ramon
- Report/Query for all advertisments of a specific user
- Prev by Date: Maximum number of Collections in SMS2003?
- Next by Date: Re: Need best free web-sms portal/tools urls
- Previous by thread: Re: Report/Query for all advertisments of a specific user
- Next by thread: SMS Reporting on a Product
- Index(es):
Relevant Pages
|
