GetPublishedViewRows

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

Note: You can review documentation for available database views in Database Views > Views Provided.

A single record of the following fields is returned.

PublishedViewRows	string	Array of row data.
Method	string	The operation that requested this response.
TransactionID	decimal	The unique message ID for this message.
ErrorMessage	string	If blank, no error was returned.
ErrorLocation	string	If blank, no error was 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>