Re: SMS SDK - Reports.create

What I am trying to do is use the SDK and VB.NET 2k5 to create reports as part of a setup vs telling poeple to importing the web report MOF then link each report to it's parent report.

I have opened a case with MS last week on this topic and they have yet to find a solution to the problem. Check out my blog tomorrow at 9:41 am EST to see what I have to say on this issue, since it will be one week with an open case on this issue.




"Nick SMS Administrator - Detroit, Mi" <NickSMSAdministratorDetroitMi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:CE2D23EE-334C-4E59-AE1E-D2DBDCEC1E9B@xxxxxxxxxxxxxxxx
Hey Garth.

I think the SDK is referencing some settings when you see the part that says
"oReport3.DisplayInComputerDetails = True"

I know there's a check mark on the 'general' tab of a reports properties
that says "Display in Computer Details". If that box is checked and you go
to your SMS reporting point's website
http:\\smsservername\smsreporing_sitecode, there are three sections; Reports,
Dashboards, and Computer Details. The reports that have that box checked
will show up under the Computer Details section.

Based on that logic, I would assume that the other parts of your query that
say "oReports3" are instructing you to set some settings in the properties of
the report.

The Microsoft SMS 2003 SDK is a reference for a "Software" Development Kit.
I'm assuming the settings "oReports3" are for if you wanted to script the
creation of a report using VBS or some sort of other scripting method. You
are just using the Admin Console.

I'm a newbie myself when it comes to report creation, but have learned a lot
in the past few months. If you are trying to limit your query to run on a
group of computers that were created with a different query, try the
subselect option for creating a collection and then run a report for "all
resources in a specific collection".

What exactly are you trying to report on?


"Garth" wrote:

I'm trying to create three web reports using the SMS SDK based on these
three queries below. I want to have each query drill through to the next
with last one drill through to Computer details.



None of the examples within the SDK show how to create a drill through
report.



Query 1

Select Manufacturer0, count(Manufacturer0) from v_GS_COMPUTER_SYSTEM group
by Manufacturer0



Query 2

SELECT v_GS_COMPUTER_SYSTEM.Name0 AS 'Name',
v_GS_COMPUTER_SYSTEM.Manufacturer0 AS 'Manufacturer',
v_GS_COMPUTER_SYSTEM.Model0 AS 'Model'

FROM v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM

WHERE (v_GS_COMPUTER_SYSTEM.Manufacturer0='Microsoft Corporation')



Query 3

SELECT v_GS_COMPUTER_SYSTEM.Name0 AS 'Name', v_GS_COMPUTER_SYSTEM.Domain0 AS
'Domain', v_GS_COMPUTER_SYSTEM.Manufacturer0 AS 'Manufacturer',
v_GS_COMPUTER_SYSTEM.Model0 AS 'Model',
v_GS_COMPUTER_SYSTEM.PrimaryOwnerName0 AS 'Owner',
v_GS_COMPUTER_SYSTEM.UserName0 AS 'User Name'

FROM v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM

WHERE (v_GS_COMPUTER_SYSTEM.Name0='Computer Name')





This section of code produces no errors when compiled however when debugged
it will produce a "Generic Failure" when the "oReport3.Save()" line is
executed.



Dim oProvider As New SMSProvider(m_sSiteServer, m_sUsername, m_sPassword, "
Setup Prog")

Dim oReport3 As SMSReport = oProvider.Reports.Create("Manufacturer ",
"Company", "SELECT v_GS_COMPUTER_SYSTEM.Name0 AS 'Name',
v_GS_COMPUTER_SYSTEM.Domain0 AS 'Domain', v_GS_COMPUTER_SYSTEM.Manufacturer0
AS 'Manufacturer', v_GS_COMPUTER_SYSTEM.Model0 AS 'Model',
v_GS_COMPUTER_SYSTEM.PrimaryOwnerName0 AS 'Owner',
v_GS_COMPUTER_SYSTEM.UserName0 AS 'User Name'

FROM v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM

WHERE (v_GS_COMPUTER_SYSTEM.Name0='Computer Name')")

oReport3.DisplayInComputerDetails = True

oReport3.ComputerNameColumn = 1

oReport3.LinkType = ReportLinkTypes.LinkToComputerDetails

oReport3.Save()

i = oReport3.ReportID



The SDK is very light on details as to which options need to be set in order
to allow drill throughs to work correctly.





My questions are?

1) Does anyone have any good examples on how to create drill through
reports?

2) Does anyone have an update to the SDK that list which options are
need to allow drill through to work correctly?

3) Does anyone know what I'm doing wrong?




Relevant Pages

  • RE: SMS SDK - Reports.create
    ... I would assume that the other parts of your query that ... The Microsoft SMS 2003 SDK is a reference for a "Software" Development Kit. ... creation of a report using VBS or some sort of other scripting method. ... I want to have each query drill through to the next ...
    (microsoft.public.sms.misc)
  • Re: SMS report to display sw and see all devices that have the sw
    ... isn't the query from below actually "Count inventoried products and versions for a specific product" report? ... if so it does not have a drilldown report. ... have this query that comes with SMS that only lists the products on all your ... > lets you then drill down and see all the devices that have the> paticular ...
    (microsoft.public.sms.misc)
  • Re: Report on connections
    ... I have installed the SDK, looked at the doc and ran the example. ... FromSheet and ToSheet onto a report. ... connections report. ... A simple example would be two processes A and B with B being dependent on ...
    (microsoft.public.visio.general)
  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
Loading