The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

SD SMS export null condition

Highlighted
HPOPV+
Collector

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
Honored Contributor

Re: SD SMS export null condition

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

Vasily
HPOPV+
Collector

Re: SD SMS export null condition

Thx for your reply,

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

//Add this to "OnDomLoad" event