Search

... be viewable on a handheld device. Following is the SQL query that goes in a notification policy: SELECT ... As far as I can tell you would have to a rather complex SQL code that makes a separate field for each queue or worker. However, I'm not really a SQL expert, so just because I can't figure out a way to do it doesn't mean it ...

Tech Tip - xenon2050 - 10 Nov 2008 - 09:23 - 6 comments - 0 attachments - 1 group

... Click to view . Now select the SQL server you want to use. This is one of the components that I will store at the domain SQL server. Select a database name or choose one from the dropdown list. ...

Article - erikw - 8 Jan 2009 - 11:43 - 0 comments - 11 attachments - 1 group

... contain spaces. To create the new view Run the following SQL Script using SQL Query Analyzer against the eXpress database: CREATE function ...

Article - vortex0007 - 14 May 2008 - 13:37 - 41 comments - 1 attachment - 1 group

... Documenting database schema is not an easy task. SQL can provide a table-column view of all selected tables, but this does not ...

Article - Joel Smith - 7 Jan 2009 - 09:45 - 0 comments - 1 attachment - 1 group

... needs. The most common way of achieving this is with a SQL table, you can create a record for each new process. Each time a task is assigned or completed update the record in SQL and report against that database. This way you will have all of the ...

Article - jason.short - 19 Nov 2008 - 12:35 - 2 comments - 1 attachment - 1 group

... view in the Altiris reports use the following script under SQL: -- Begin of create view in Altiris Use Altiris Go Create view ... ( 21 votes) Alternate soltuion with SQL 2007 We have Helpdesk running on a SQL 2007 backbone, and because of ...

Article - Fabrice B M Raud - 10 Dec 2008 - 12:19 - 2 comments - 1 attachment - 1 group

... Rules. You can edit the the SQL if you want to shorten or lengthen the time of the config request ...

Download - EMercado - 16 Dec 2008 - 13:33 - 3 comments - 2 attachments - 1 group

... You can use the following report either directly in SQL, or copying it into the NS Report builder "Enter SQL Directly" --= --= Report to display all active workers in the ...

Download - kpjernigan - 23 Dec 2008 - 15:35 - 1 comment - 2 attachments - 1 group

... Notification Policies The user defined SQL functions Database table and view changes ... Policies Execute the SLA_Setup_v2.2.sql script against the SQL Server database hosting the Notification Server and Service Desk ...

Article - Scott Hardie - 14 Nov 2008 - 13:20 - 12 comments - 3 attachments - 2 groups

... You can overcome this error by running the following SQL Query against the Deployment Server Database: "CREATE TABLE hii_settings ... for the HII Tools to work properly. HII 3.2.1 SQL Compatibility is HII 3.2.1 compatible with all versions of SQL? Will it ...

Download - CondorMan - 13 Feb 2008 - 10:31 - 60 comments - 1 attachment - 2 groups