Here is my SQL Logging. It shows the SQL query, but not the data returned:
<SQL > <TID: 0000001984> <RPC ID: 0000000206> <Queue: Admin >
<Client-RPC: 390600 > <USER: brooksm
> /* Thu Jun 21 2007 11:58:09.5780 */SQL Trace Log -- ON
<SQL > <TID: 0000001984> <RPC ID: 0000000213> <Queue: Admin >
<Client-RPC: 390600 > <USER: brooksm
> /* Thu Jun 21 2007 11:58:09.6870 */SELECT checkInterval FROM
servgrp_config
<SQL > <TID: 0000001984> <RPC ID: 0000000213> <Queue: Admin >
<Client-RPC: 390600 > <USER: brooksm
> /* Thu Jun 21 2007 11:58:09.6870 */SELECT name FROM servgrp_config
<SQL > <TID: 0000001984> <RPC ID: 0000000213> <Queue: Admin >
<Client-RPC: 390600 > <USER: brooksm
> /* Thu Jun 21 2007 11:58:09.6870 */SELECT COUNT(*) FROM ft_pending WHERE
operationType = 6
<SQL > <TID: 0000002676> <RPC ID: 0000000214> <Queue: List >
<Client-RPC: 390620 > <USER: brooksm
> /* Thu Jun 21 2007 11:58:27.3280 */SELECT actlinkId from actlink where
name = 'dAltiris'
<SQL > <TID: 0000002676> <RPC ID: 0000000214> <Queue: List >
<Client-RPC: 390620 > <USER: brooksm
> /* Thu Jun 21 2007 11:58:27.3750 */SELECT assignShort,assignLong FROM
actlink_set WHERE actlinkId = 6460 AND actionIndex = 0
<SQL > <TID: 0000002676> <RPC ID: 0000000214> <Queue: List >
<Client-RPC: 390620 > <USER: brooksm
> /* Thu Jun 21 2007 11:58:27.3750 */BEGIN TRANSACTION
<SQL > <TID: 0000002676> <RPC ID: 0000000214> <Queue: List >
<Client-RPC: 390620 > <USER: brooksm
> /* Thu Jun 21 2007 11:58:27.3750 */SELECT * FROM
OPENQUERY([D-DBSERVER],'SELECT vc.[Guid],
vc.[Name],
vc.[User],
sn.[System Manufacturer],
sn.[Computer Model],
sn.[Serial Number]
FROM vComputer vc
LEFT JOIN Inv_AeX_HW_Serial_Number sn
ON vc.[Guid] = sn.[_ResourceGuid]
ORDER BY sn.[Computer Model]')
<SQL > <TID: 0000002676> <RPC ID: 0000000214> <Queue: List >
<Client-RPC: 390620 > <USER: brooksm
> /* Thu Jun 21 2007 11:58:27.8750 */COMMIT TRANSACTION
<SQL > <TID: 0000001984> <RPC ID: 0000000215> <Queue: Admin >
<Client-RPC: 390600 > <USER: brooksm
> /* Thu Jun 21 2007 11:58:47.8280 */SQL Trace Log -- OFF
Kaiser Norm E CIV USAF 96 CS/SCCE wrote:
>
> Have you tried turning on SQL logging at the server and taking a look at
> exactly what Remedy is passing to the SQL server and what the SQL server
> is returning?
>
> -----Original Message-----
> From: Action Request System discussion list(ARSList)
> [mailto:[EMAIL PROTECTED] On Behalf Of brooksm
> Sent: Thursday, June 21, 2007 1:11 AM
> To: [email protected]
> Subject: Odd results in Active Link SQL Set Fields
>
> I've created a SQL view from another SQL Server 2005 database. When I
> run a
> query on this view ins SQL Server management Studio, everything works as
> expected. But when I do a SQL Set fields Active Link, I only get 29
> characters in the field. Here is the SQL that I used to create my view:
>
> CREATE VIEW [dbo].[VIEW_ALT_ASSETS_USERS] AS
> SELECT * FROM OPENQUERY([D-DBSERVER],'SELECT vc.[Guid],
> vc.[Name],
> vc.[User],
> sn.[System Manufacturer],
> sn.[Computer Model],
> sn.[Serial Number]
> FROM vComputer vc
> LEFT JOIN Inv_AeX_HW_Serial_Number sn
> ON vc.[Guid] = sn.[_ResourceGuid]
> ORDER BY sn.[Computer Model]')
>
> My problem is the Guid field. Querying this view in SQL Server
> Management
> Studio gives me values like this:
> 51A22A9E-2AE1-422F-B99C-53B841D38C92
>
> But when I do the same query in my Set fields AL, I get this returned:
> {51A22A9E-2AE1-422F-B99C-53B8
>
> Note the "{" and the trailing 8 characters missing.
>
> I'm stumped... Anyone have an idea?
>
> Thanks
> Brooks
> --
> View this message in context:
> http://www.nabble.com/Odd-results-in-Active-Link-SQL-Set-Fields-tf395673
> 8.html#a11227200
> Sent from the ARS (Action Request System) mailing list archive at
> Nabble.com.
>
> ________________________________________________________________________
> _______
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
> the Answers Are"
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where
> the Answers Are"
>
>
--
View this message in context:
http://www.nabble.com/Odd-results-in-Active-Link-SQL-Set-Fields-tf3956738.html#a11239497
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
