Re: SQL query in web reporting

In article <43318F16.10407@xxxxxxxxxxxxx>, hermes@xxxxxxxxxxxxx says...
> Thank you Lars for your quick and helpful response! I made the changes
> you suggested, and now I get a different error as follows:
>
> Internet Explorer
> Problems with this web page might prevent it from being displayed
> properly or functioning properly. In the future, you can display this
> message by double-clicking the warning icon displayed in the status bar.
>
> Line 16
> Char 2
> Error: Access is denied
> Code 0
> URL http://server/sms_s01/custom/custommain.asp
>
> It seems as though it is an Internet Explorer error instead of a query
> syntax error. So again, I thank you for fixing my query syntax error,
> but now I am wondering if you or anyone else has a suggestion about this
> IE error? Has it something to do with permissions on the tables or SMS
> web reporting webpage? Thanks again.
>
>
>
> Lars Norman Søndergaard wrote:
> > Hi,
> >
> > You have a few bugs:
> >
> > On line 66 and 137 you are missing a _
> > In the from part you are using some wrong tables (views): v_gs_video should
> > be v_gs_video_controller and v_gs_audio should be v_gs_audio_device.
> >
> > You are referening two tables that I do not know about:
> > v_gs_display_controller_confi and v_gs_display_configuration.
> >
> > Lars Norman Søndergaard
> >
> >
> > "hermes" <hermes@xxxxxxxxxxxxx> skrev i en meddelelse
> > news:%23cVEQ5hvFHA.3124@xxxxxxxxxxxxxxxxxxxxxxx
> >
> >>I have written this query, and I keep getting this error message when I try
> >>to run it (Line 1: Incorrect syntax near '.'.). Does anyone have some
> >>suggestions as to what the error means or why it might not be working? I
> >>look over and over it but I can't figure out what is wrong with my query
> >>and I can find no syntax errors. Thanks.
> >>
> >>SELECT
> >>
> >>v_GS_DISK.Description0,
> >>v_GS_DISK.DeviceID0,
Is your user account a member of the sms reporting users group on the
reporting point?
If so, does your account have permissions to the report in sms?
--
Kim Oppalfens
MVP SMS
Computacenter Belgium
.

Relevant Pages

  • Re: SQL query in web reporting
    ... So again, I thank you for fixing my query syntax error, but now I am wondering if you or anyone else has a suggestion about this IE error? ... Has it something to do with permissions on the tables or SMS web reporting webpage? ... I don't think that it is a problem with permissions to the report because I get this message when I enter the query initially on the custom reports screen in order to display it then save it. ...
    (microsoft.public.sms.admin)
  • Re: SMS Reports-prompts for username/password? SP1
    ... Add the reporting site to the intranet zone in internet explorer. ... Disabling this feature in Add/remove programs windows components is ... MVP SMS ...
    (microsoft.public.sms.admin)
  • RE: Problems with SMS_COLLECTION_EVALUATOR
    ... Nope, no bug, neither in DB nor sms. ... By default sms is set to start reporting warnings if a certain component ... > Component Status Summarizer set the status of component ... Monitor the component occasionally to verify the problem does not reoccur. ...
    (microsoft.public.sms.admin)
  • Re: How to add multiple computers into collection
    ... An alternative would be to build queries that expose the ... Package and Collection data from the database using WQL ... Put the following query code in to the respective query ... specify the sms site servers name. ...
    (microsoft.public.sms.admin)
  • Re: SMS Admin MMC cannot locate the site database
    ... Once you open WBEMTEST and connect to your namespace, ... main window and select the query button, then put it the query string I ... First confirm you have WMI connectivity to your site server. ... You should get an entry back with a namespace path to the actual SMS ...
    (microsoft.public.sms.admin)
Quantcast