Re: Report/Query for all advertisments of a specific user

Tech-Archive recommends: Speed Up your PC by fixing your registry

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
>>
>
>


.

Relevant Pages

  • Re: Report/Query for all advertisments of a specific user
    ... the resourceID you get from V_ClientAdvertisementStatus is the ... > posible to see the advertisements of a user but I want to create a report ... >> Hi Ramon, ... >> can join users to machines. ...
    (microsoft.public.sms.misc)
  • Report/Query for all advertisments of a specific user
    ... I want to create a query to find all the advertisements a specific user gets ... CollectionID from the view 'v_Advertisement' it is possible to retrieve the ...
    (microsoft.public.sms.misc)
  • Re: Newbie Question: MySQL Rows
    ... The number of rows returned by a SELECT query is available using the ... select maxfrom advertisements where ad_number < 12 ... where banner ads can be added. ... I do have a adNum column in the table ...
    (alt.php)