Service Desk Practitioners Forum
cancel

SD SMS export null condition

Highlighted
HPOPV+
Honored Contributor.

SD SMS export null condition

Hi,
I have SD5.1 patch1 installed on windows 2003 sp1 se server. SMS using MsSql 2000
I did the odbc connection but While doing the export i get the values but i get null values too.
What is the condition to make the field different from null. I tried the following in the ini file and it didnt work.
CONDITION=(field=*) (this one worked with ldap integration)
CONDITION=(field <> null)
CONDITION=(field != null)
CONDITION=(field <> 0)
CONDITION=(field != 0)

Does anyone knows what is the syntax so that i dont get null values

Regards;

2 REPLIES
Vasily Kamenev
Acclaimed Contributor.

Re: SD SMS export null condition

HI
Before (in 4.5) that was:
CONDITION = not( is NULL)

Vasily
HPOPV+
Honored Contributor.

Re: SD SMS export null condition

Thx for your reply,

I used CONDITION=([tablename].[Columnname] not like 'NULL')
and it worked