GetPublishedViewRows

Returns an array of all rows for a published database view given a WHERE clause.

A single record of the following fields is returned.

Example

Note: The following example was executed using the test page published with every installation, located at http://localhost/vsaWS/testClient/testClient.asp.

Request

<req>

  <viewName>vScriptLog</viewName>

  <columnsList>AdminName,agentGuid,EventTime,Machine_GroupID,ScriptDesc,ScriptName</columnsList>

  <whereClause>EventTime > DATEADD(hour,4,getdate())</whereClause>

  <orderByList>agentGuid,EventTime</orderByList>

  <ReturnAllRows>false</ReturnAllRows>

  <SessionID>42131527423841487151422001</SessionID>

</req>

SQL Equivalent

select top 5000 AdminName,agentGuid,EventTime,Machine_GroupID,ScriptDesc,ScriptName
from vScriptLog
where EventTime > DATEADD(hour,-4,getdate())
order by agentGuid,EventTime

Selects 6 of 8 available columns from vScriptLog where activity occurred within the past 4 hours and sorts the results by machine, then activity date.

Note: When <ReturnAllRows> is set false, a rowset maximum of 5000 is applied to protect the database from overly large resultsets.

Response

<GetPublishedViewRowsResponse>

  <GetPublishedViewRowsResult>

    <PublishedViewRows>

      <vScriptLog>

        <Row>

          <AdminName>*System*</AdminName>

          <agentGuid>517481450374694</agentGuid>

          <EventTime>20100913T09:24:1905:00</EventTime>

          <Machine_GroupID>xpprox86001.agents.hyperv.kserver</Machine_GroupID>

          <ScriptDesc>Script Summary: Success THEN</ScriptDesc>

          <ScriptName>KES Update AVG via Internet</ScriptName>

        </Row>

        <Row>

          <AdminName>*System*</AdminName>

          <agentGuid>517481450374694</agentGuid>

          <EventTime>20100913T09:24:20.00305:00</EventTime>

          <Machine_GroupID>xpprox86001.agents.hyperv.kserver</Machine_GroupID>

          <ScriptDesc>Script Summary: Success THEN</ScriptDesc>

          <ScriptName>KES Update</ScriptName>

        </Row>

        <Row>

          <AdminName>*System*</AdminName>

          <agentGuid>517481450374694</agentGuid>

          <EventTime>20100913T09:24:20.00705:00</EventTime>

          <Machine_GroupID>xpprox86001.agents.hyperv.kserver</Machine_GroupID>

          <ScriptDesc>Script Summary: Success THEN</ScriptDesc>

          <ScriptName>Run Now  KES Update</ScriptName>

        </Row>

      </vScriptLog>

    </PublishedViewRows>

    <Method>GetPublishedViewRows</Method>

    <TransactionID>4</TransactionID>

    <ErrorMessage/>

    <ErrorLocation/>

  </GetPublishedViewRowsResult>

</GetPublishedViewRowsResponse>

Topic 5444: Send Feedback. Download a PDF of this online book from the first topic in the table of contents. Print this topic.