<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
		<id>http://greggsmith.net/wiki/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Erik.johnson</id>
		<title>SDU - User contributions [en]</title>
		<link rel="self" type="application/atom+xml" href="http://greggsmith.net/wiki/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Erik.johnson"/>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Special:Contributions/Erik.johnson"/>
		<updated>2026-07-27T12:30:42Z</updated>
		<subtitle>User contributions</subtitle>
		<generator>MediaWiki 1.26.1</generator>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=EIAM_Services_dont_start_on_fresh_install&amp;diff=4057</id>
		<title>EIAM Services dont start on fresh install</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=EIAM_Services_dont_start_on_fresh_install&amp;diff=4057"/>
				<updated>2010-03-30T16:33:51Z</updated>
		
		<summary type="html">&lt;p&gt;Erik.johnson: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;'''EIAM does not start on install'''&lt;br /&gt;
&lt;br /&gt;
I had to install Service Desk, Service Catalog and Workflow on a very new image. I started with the install shield and went through the instructions and steps provided for a clean install of all this products. Though I did not recieve any error's while I was doing the install, I still could not get the EIAM services to start. &amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
When I looked at the services on the server, I could see the eTrust Directory services were stopped and would not start when I try manually or through command line. I was not getting enough help from the log's to narrow down the problem. &amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
Finally, not have anywhere to go, I uninstalled all the Unicenter products and rebooted the machine and tried to install again, but this time I was using another User ID logging into the server. [Note: The permissions on both the id's I used were exactly the same and were a part of Administrative Group on the local machine].&lt;br /&gt;
 &lt;br /&gt;
'''This time, I was able to successfully install everything and also had the EIAM working, wondering what might be the issue...we noticed that when you install the CA products it does not like the user account to be all numbers. In our environment, and in this particular case, our USER ID to login to the server are 9 digit numbers. EIAM does not like userid to be starting with a number'''&lt;br /&gt;
&lt;br /&gt;
The second time I installed the products again, I used a alpha-numeric userid and everything worked normal.&lt;br /&gt;
&lt;br /&gt;
Thought I will share this with anyone who might have faced a similar issue.&lt;br /&gt;
&lt;br /&gt;
Thanks &amp;lt;br&amp;gt;&lt;br /&gt;
AKM&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Update by Erik:&lt;br /&gt;
&lt;br /&gt;
I encountered a similar problem on our test server, and a full wipe and reinstall didn't fix it, nor did a database wipe. I think it may be hardware specific, because we are using an account with no numerals in it. Our problem was that EIAM was taking a very long time to load, and the Unicenter Service cannot start until this is done, but it does not intuitively know that it needs to wait so Services would have to be manually started each time. The only way I was able to reconcile this was to create Service dependencies so that the Unicenter Service will not try to start until the EIAM (eTrust) Services have. The settings for such a configuration get wiped out upon reboot, so I had to put it into a batch file and have it run as a scheduled task on Startup to ensure the process was followed.&lt;br /&gt;
&lt;br /&gt;
Here's the code from the batch file (Service dependencies separated by a '/' as per sc.exe syntax):&amp;lt;br&amp;gt;&lt;br /&gt;
@echo off&amp;lt;br&amp;gt;&lt;br /&gt;
c:\windows\system32\dllcache\sc.exe config pdm_daemon_manager depend= DXserver_iTechPoz-SERVER_HOSTNAME/DXserver_iTechPoz-SERVER_HOSTNAME-Router/ssld_iTechPoz-Server/dxadmind_master&lt;/div&gt;</summary>
		<author><name>Erik.johnson</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=EIAM_Services_dont_start_on_fresh_install&amp;diff=4056</id>
		<title>EIAM Services dont start on fresh install</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=EIAM_Services_dont_start_on_fresh_install&amp;diff=4056"/>
				<updated>2010-03-30T16:32:33Z</updated>
		
		<summary type="html">&lt;p&gt;Erik.johnson: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;'''EIAM does not start on install'''&lt;br /&gt;
&lt;br /&gt;
I had to install Service Desk, Service Catalog and Workflow on a very new image. I started with the install shield and went through the instructions and steps provided for a clean install of all this products. Though I did not recieve any error's while I was doing the install, I still could not get the EIAM services to start. &amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
When I looked at the services on the server, I could see the eTrust Directory services were stopped and would not start when I try manually or through command line. I was not getting enough help from the log's to narrow down the problem. &amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
Finally, not have anywhere to go, I uninstalled all the Unicenter products and rebooted the machine and tried to install again, but this time I was using another User ID logging into the server. [Note: The permissions on both the id's I used were exactly the same and were a part of Administrative Group on the local machine].&lt;br /&gt;
 &lt;br /&gt;
'''This time, I was able to successfully install everything and also had the EIAM working, wondering what might be the issue...we noticed that when you install the CA products it does not like the user account to be all numbers. In our environment, and in this particular case, our USER ID to login to the server are 9 digit numbers. EIAM does not like userid to be starting with a number'''&lt;br /&gt;
&lt;br /&gt;
The second time I installed the products again, I used a alpha-numeric userid and everything worked normal.&lt;br /&gt;
&lt;br /&gt;
Thought I will share this with anyone who might have faced a similar issue.&lt;br /&gt;
&lt;br /&gt;
Thanks &amp;lt;br&amp;gt;&lt;br /&gt;
AKM&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Update by Erik:&lt;br /&gt;
&lt;br /&gt;
I encountered a similar problem on our test server, and a full wipe and reinstall didn't fix it, nor did a database wipe. I think it may be hardware specific, because we are using an account with no numerals in it. Our problem was that EIAM was taking a very long time to load, and the Unicenter Service cannot start until this is done, but it does not intuitively know that it needs to wait so Services would have to be manually started each time. The only way I was able to reconcile this was to create Service dependencies so that the Unicenter Service will not try to start until the EIAM (eTrust) Services have. The settings for such a configuration get wiped out upon reboot, so I had to put it into a batch file and have it run as a scheduled task on Startup to ensure the process was followed.&lt;br /&gt;
&lt;br /&gt;
Here's the code from the batch file:&amp;lt;br&amp;gt;&lt;br /&gt;
@echo off&amp;lt;br&amp;gt;&lt;br /&gt;
c:\windows\system32\dllcache\sc.exe config pdm_daemon_manager depend= DXserver_iTechPoz-SERVER_HOSTNAME/DXserver_iTechPoz-SERVER_HOSTNAME-Router/ssld_iTechPoz-Server/dxadmind_master&lt;/div&gt;</summary>
		<author><name>Erik.johnson</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=EIAM_Services_dont_start_on_fresh_install&amp;diff=4055</id>
		<title>EIAM Services dont start on fresh install</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=EIAM_Services_dont_start_on_fresh_install&amp;diff=4055"/>
				<updated>2010-03-30T16:31:31Z</updated>
		
		<summary type="html">&lt;p&gt;Erik.johnson: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;'''EIAM does not start on install'''&lt;br /&gt;
&lt;br /&gt;
I had to install Service Desk, Service Catalog and Workflow on a very new image. I started with the install shield and went through the instructions and steps provided for a clean install of all this products. Though I did not recieve any error's while I was doing the install, I still could not get the EIAM services to start. &amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
When I looked at the services on the server, I could see the eTrust Directory services were stopped and would not start when I try manually or through command line. I was not getting enough help from the log's to narrow down the problem. &amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
Finally, not have anywhere to go, I uninstalled all the Unicenter products and rebooted the machine and tried to install again, but this time I was using another User ID logging into the server. [Note: The permissions on both the id's I used were exactly the same and were a part of Administrative Group on the local machine].&lt;br /&gt;
 &lt;br /&gt;
'''This time, I was able to successfully install everything and also had the EIAM working, wondering what might be the issue...we noticed that when you install the CA products it does not like the user account to be all numbers. In our environment, and in this particular case, our USER ID to login to the server are 9 digit numbers. EIAM does not like userid to be starting with a number'''&lt;br /&gt;
&lt;br /&gt;
The second time I installed the products again, I used a alpha-numeric userid and everything worked normal.&lt;br /&gt;
&lt;br /&gt;
Thought I will share this with anyone who might have faced a similar issue.&lt;br /&gt;
&lt;br /&gt;
Thanks &amp;lt;br&amp;gt;&lt;br /&gt;
AKM&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Update by Erik:&lt;br /&gt;
&lt;br /&gt;
I encountered a similar problem on our test server, and a full wipe and reinstall didn't fix it, nor did a database wipe. I think it may be hardware specific, because we are using an account with no numerals in it. Our problem was that EIAM was taking a very long time to load, and the Unicenter Service cannot start until this is done, but it does not intuitively know that it needs to wait so Services would have to be manually started each time. The only way I was able to reconcile this was to create Service dependencies so that the Unicenter Service will not try to start until the EIAM (eTrust) Services have. The settings for such a configuration get wiped out upon reboot, so I had to put it into a batch file and have it run as a scheduled task on Startup to ensure the process was followed.&lt;br /&gt;
&lt;br /&gt;
Here's the code from the batch file.&lt;br /&gt;
@echo off&lt;br /&gt;
c:\windows\system32\dllcache\sc.exe config pdm_daemon_manager depend= DXserver_iTechPoz-SERVER_HOSTNAME/DXserver_iTechPoz-SERVER_HOSTNAME-Router/ssld_iTechPoz-Server/dxadmind_master&lt;/div&gt;</summary>
		<author><name>Erik.johnson</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=EIAM_Services_dont_start_on_fresh_install&amp;diff=4053</id>
		<title>EIAM Services dont start on fresh install</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=EIAM_Services_dont_start_on_fresh_install&amp;diff=4053"/>
				<updated>2010-03-30T16:25:21Z</updated>
		
		<summary type="html">&lt;p&gt;Erik.johnson: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;'''EIAM does not start on install'''&lt;br /&gt;
&lt;br /&gt;
I had to install Service Desk, Service Catalog and Workflow on a very new image. I started with the install shield and went through the instructions and steps provided for a clean install of all this products. Though I did not recieve any error's while I was doing the install, I still could not get the EIAM services to start. &amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
When I looked at the services on the server, I could see the eTrust Directory services were stopped and would not start when I try manually or through command line. I was not getting enough help from the log's to narrow down the problem. &amp;lt;br&amp;gt;&lt;br /&gt;
&lt;br /&gt;
Finally, not have anywhere to go, I uninstalled all the Unicenter products and rebooted the machine and tried to install again, but this time I was using another User ID logging into the server. [Note: The permissions on both the id's I used were exactly the same and were a part of Administrative Group on the local machine].&lt;br /&gt;
 &lt;br /&gt;
'''This time, I was able to successfully install everything and also had the EIAM working, wondering what might be the issue...we noticed that when you install the CA products it does not like the user account to be all numbers. In our environment, and in this particular case, our USER ID to login to the server are 9 digit numbers. EIAM does not like userid to be starting with a number'''&lt;br /&gt;
&lt;br /&gt;
The second time I installed the products again, I used a alpha-numeric userid and everything worked normal.&lt;br /&gt;
&lt;br /&gt;
Thought I will share this with anyone who might have faced a similar issue.&lt;br /&gt;
&lt;br /&gt;
Thanks &amp;lt;br&amp;gt;&lt;br /&gt;
AKM&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Update by Erik:&lt;br /&gt;
&lt;br /&gt;
I encountered this problem on our test server, and a full wipe and reinstall didn't fix it, nor did a database wipe. I think it may be hardware specific, because we are using an account with no numerals in it. The only way I was able to reconcile this was to create Service dependencies so that the Unicenter Service will not try to start until the EIAM (eTrust) Services have. The settings for such a configuration get wiped out upon reboot, so I had to put it into a batch file and have it run as a scheduled task on Startup to ensure the process was followed.&lt;br /&gt;
&lt;br /&gt;
Here's the code from the batch file.&lt;br /&gt;
@echo off&lt;br /&gt;
c:\windows\system32\dllcache\sc.exe config pdm_daemon_manager depend= DXserver_iTechPoz-SERVER_HOSTNAME/DXserver_iTechPoz-SERVER_HOSTNAME-Router/ssld_iTechPoz-Server/dxadmind_master&lt;/div&gt;</summary>
		<author><name>Erik.johnson</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Stored_Queries&amp;diff=3985</id>
		<title>Stored Queries</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Stored_Queries&amp;diff=3985"/>
				<updated>2009-10-23T00:09:43Z</updated>
		
		<summary type="html">&lt;p&gt;Erik.johnson: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;[[Category:Configuration]]&lt;br /&gt;
{{Global Header}}&lt;br /&gt;
{{Global Announcement}}&lt;br /&gt;
&lt;br /&gt;
== Overview ==&lt;br /&gt;
Stored Queries are used exclusively for the [[Scoreboard]]. Stored Queries have no capabilities or functionality outside of the Scoreboard.&lt;br /&gt;
&lt;br /&gt;
When defining Stored Query you must prefix all single quotation marks (') with backslash (\) character.&lt;br /&gt;
&lt;br /&gt;
To simply check Stored Query you can fill it into the Additional Search Argument field in the Search window. But you must fulfill these rules:&lt;br /&gt;
* Select proper base type (Contact, Request, Change...)&lt;br /&gt;
* Remove backslash (\) characters&lt;br /&gt;
* Change all variables (ie. @cnt.id) with correct values (@cnt is object with logged in user)&lt;br /&gt;
&lt;br /&gt;
== Examples ==&lt;br /&gt;
=== Requests, Incidents, Problems, Change Orders &amp;amp; Issues ===&lt;br /&gt;
{| style=&amp;quot;width:100%;vertical-align:top;&amp;quot;&lt;br /&gt;
|-&lt;br /&gt;
! style=&amp;quot;width:30%;&amp;quot; | Description&lt;br /&gt;
! style=&amp;quot;width:40%;&amp;quot; | Code&lt;br /&gt;
! style=&amp;quot;width:30%;&amp;quot; | Notes&lt;br /&gt;
|-&lt;br /&gt;
| Active&lt;br /&gt;
| active = 1&lt;br /&gt;
| &lt;br /&gt;
|-&lt;br /&gt;
| Inactive&lt;br /&gt;
| active = 0&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Has Assignee&lt;br /&gt;
| assignee is not null&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| No Assignee&lt;br /&gt;
| assignee is null&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Assignee is the person logged in&lt;br /&gt;
| assignee = @cnt.id&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Affected End User is the person logged in&lt;br /&gt;
| customer = @cnt.id&lt;br /&gt;
| Requests, Incidents &amp;amp; Problems only&lt;br /&gt;
|-&lt;br /&gt;
| Affected End User's Location&lt;br /&gt;
| customer.location = U\'A26C98F436C43149A700CC0ED3BA74E5\'&lt;br /&gt;
| Requests, Incidents &amp;amp; Problems only&lt;br /&gt;
|-&lt;br /&gt;
| Affected End User's Location contains specific text&lt;br /&gt;
| customer.location.name like \'%keyword%\'&lt;br /&gt;
|-&lt;br /&gt;
| Affected End User's Site&lt;br /&gt;
| customer.location.site = 400001&lt;br /&gt;
| Requests, Incidents &amp;amp; Problems only&lt;br /&gt;
|-&lt;br /&gt;
| Affected End User's Location is the same as the person logged in&lt;br /&gt;
| customer.location = @cnt.location&lt;br /&gt;
| Requests, Incidents &amp;amp; Problems only&lt;br /&gt;
|-&lt;br /&gt;
| Affected End User's Site is the same as the person logged in&lt;br /&gt;
| customer.location.site = @cnt.location.site&lt;br /&gt;
| Requests, Incidents &amp;amp; Problems only&lt;br /&gt;
|-&lt;br /&gt;
| Affected End User is the person logged in&lt;br /&gt;
| customer = @cnt.id&lt;br /&gt;
| Requests, Incidents &amp;amp; Problems only&lt;br /&gt;
|-&lt;br /&gt;
| Attached CO&lt;br /&gt;
| (change IS NOT NULL AND change != 0)&lt;br /&gt;
| Requests, Incidents &amp;amp; Problems only&lt;br /&gt;
|-&lt;br /&gt;
| Affected End User is the person logged in&lt;br /&gt;
| affected_contact = @cnt.id&lt;br /&gt;
| Applies to Change Orders and Issues only&lt;br /&gt;
|-&lt;br /&gt;
| Affected End User's Location&lt;br /&gt;
| affected_contact.location = U\'A26C98F436C43149A700CC0ED3BA74E5\'&lt;br /&gt;
| Applies to Change Orders and Issues only&lt;br /&gt;
|-&lt;br /&gt;
| Affected End User's Site&lt;br /&gt;
| affected_contact.location.site = 400001&lt;br /&gt;
| Applies to Change Orders and Issues only&lt;br /&gt;
|-&lt;br /&gt;
| Affected End User's Location is the same as the person logged in&lt;br /&gt;
| affected_contact.location = @cnt.location&lt;br /&gt;
| Applies to Change Orders and Issues only&lt;br /&gt;
|-&lt;br /&gt;
| Affected End User's Location contains specific text&lt;br /&gt;
| affected_contact.location.name like \'%keyword%\'&lt;br /&gt;
| Applies to Change Orders and Issues only&lt;br /&gt;
|-&lt;br /&gt;
| Affected End User's Site is the same as the person logged in&lt;br /&gt;
| affected_contact.location.site = @cnt.location.site&lt;br /&gt;
| Applies to Change Orders and Issues only&lt;br /&gt;
|-&lt;br /&gt;
| Requester is the person logged in&lt;br /&gt;
| requestor = @cnt.id&lt;br /&gt;
| Applies to Change Orders and Issues only&lt;br /&gt;
|-&lt;br /&gt;
| Callback Today&lt;br /&gt;
| call_back_flag=1 AND call_back_date &amp;lt; EndAtTime(\'TODO_TODAY\')&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Category or Request/Incident/Problem Area is specific&lt;br /&gt;
| category.id = nnnnnn&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Group is specific&lt;br /&gt;
| group=U\'7D15BCD6D0B7E8468E58EA600E61F484\'&lt;br /&gt;
| For pre-r11 releases, just reference the id.&lt;br /&gt;
|-&lt;br /&gt;
| Member of the Group is the person logged in&lt;br /&gt;
| group.group_list.member IN (@cnt.id)&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Created by the person logged on&lt;br /&gt;
| log_agent = @cnt.id&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Priority is 1&lt;br /&gt;
| priority = 5&lt;br /&gt;
| References the enum value not the sym value.&lt;br /&gt;
|-&lt;br /&gt;
| Priority is 5&lt;br /&gt;
| priority = 1&lt;br /&gt;
| References the enum value not the sym value.&lt;br /&gt;
|-&lt;br /&gt;
| Resolved&lt;br /&gt;
| active = 1 and status = \'RE\'&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| SLA has been violated&lt;br /&gt;
| sla_violation = 0&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| SLA has not been violated&lt;br /&gt;
| sla_violation != 0&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Created in the past 60 minutes&lt;br /&gt;
| open_date &amp;gt; StartAtTime(\'PAST_HOUR\')&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Created in the past 24 hours&lt;br /&gt;
| open_date &amp;gt; StartAtTime(\'PAST_DAY\')&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Created in the past 7 days&lt;br /&gt;
| open_date &amp;gt; StartAtTime(\'PAST_WEEK\')&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Created in the past 30 days&lt;br /&gt;
| open_date &amp;gt; StartAtTime(\'PAST_MONTH\')&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Created in the past 365 days&lt;br /&gt;
| open_date &amp;gt; StartAtTime(\'PAST_YEAR\')&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Created last hour&lt;br /&gt;
| open_date &amp;gt; StartAtTime(\'LAST_HOUR\')&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Created last month&lt;br /&gt;
| open_date &amp;gt; StartAtTime(\'LAST_MONTH\')&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Created last year&lt;br /&gt;
| open_date &amp;gt; StartAtTime(\'LAST_YEAR\')&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Created this hour&lt;br /&gt;
| open_date &amp;gt; StartAtTime(\'THIS_HOUR\')&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Created this month last year&lt;br /&gt;
| open_date &amp;gt; StartAtTime(\'THIS_MONTH_LAST_YEAR\')&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Created today&lt;br /&gt;
| open_date &amp;gt; StartAtTime(\'TODAY\')&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Created today after noon&lt;br /&gt;
| open_date &amp;gt; StartAtTime(\'AFTER_NOON\')&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Created today before noon&lt;br /&gt;
| open_date &amp;gt; StartAtTime(\'BEFORE_NOON\')&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Created yesterday&lt;br /&gt;
| open_date &amp;gt; StartAtTime(\'YESTERDAY\') AND open_date &amp;lt; EndAtTime(\'YESTERDAY\')&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Created yesterday and today&lt;br /&gt;
| open_date &amp;gt; StartAtTime(\'YESTERDAY\')&lt;br /&gt;
|-&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
=== Workflow &amp;amp; Issue Workflow ===&lt;br /&gt;
{| style=&amp;quot;width:100%;&amp;quot;&lt;br /&gt;
|-&lt;br /&gt;
! style=&amp;quot;width:30%;&amp;quot; | Description&lt;br /&gt;
! style=&amp;quot;width:40%;&amp;quot; | Code&lt;br /&gt;
! style=&amp;quot;width:30%;&amp;quot; | Notes&lt;br /&gt;
|-&lt;br /&gt;
| Assignee is logged in person&lt;br /&gt;
| assignee = @cnt.id&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Assignee is a specific Group&lt;br /&gt;
| assignee=U\'7D15BCD6D0B7E8468E58EA600E61F484\'&lt;br /&gt;
| &lt;br /&gt;
|-&lt;br /&gt;
| Logged in person is a member of the Group set as the Assignee&lt;br /&gt;
| assignee.[group]group_list.member IN (@cnt.id)&lt;br /&gt;
| &lt;br /&gt;
|-&lt;br /&gt;
| Group is specific&lt;br /&gt;
| group=U\'7D15BCD6D0B7E8468E58EA600E61F484\'&lt;br /&gt;
| &lt;br /&gt;
|-&lt;br /&gt;
| Future&lt;br /&gt;
| status.allow_task_update = 0 AND status = \'WAIT\'&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Waiting&lt;br /&gt;
| status = \'WAIT\'&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Pending&lt;br /&gt;
| status = \'PEND\'&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| To do today&lt;br /&gt;
| status = \'PEND\' AND est_completion_date &amp;lt; EndAtTime(\'TODO_TODAY\')&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Cannot be edited&lt;br /&gt;
| status.allow_task_update = 0&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Is not complete&lt;br /&gt;
| status.task_complete = 0&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Is not next in the Workflow&lt;br /&gt;
| status.do_next_task = 0&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
=== Contacts ===&lt;br /&gt;
{| style=&amp;quot;width:100%;&amp;quot;&lt;br /&gt;
|-&lt;br /&gt;
! style=&amp;quot;width:30%;&amp;quot; | Description&lt;br /&gt;
! style=&amp;quot;width:40%;&amp;quot; | Code&lt;br /&gt;
! style=&amp;quot;width:30%;&amp;quot; | Notes&lt;br /&gt;
|-&lt;br /&gt;
| All Analysts&lt;br /&gt;
| type = 2307&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Analyst is available&lt;br /&gt;
| available = 1&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Analyst is unavailable&lt;br /&gt;
| available=0 OR available IS NULL&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Contact is active&lt;br /&gt;
| delete_flag = 1&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Contact is inactive&lt;br /&gt;
| delete_flag = 0&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Contact's Location is the same as the logged in person's Location&lt;br /&gt;
| location = @cnt.location&lt;br /&gt;
|&lt;br /&gt;
|-&lt;br /&gt;
| Members of concrete group&lt;br /&gt;
| id.[member]group_list.group IN (U\'0969194BE95B974F9535687570A8E5B1\')&lt;br /&gt;
| U\'0969194BE95B974F9535687570A8E5B1\' is an contact_uuid attribute of the group&lt;br /&gt;
|-&lt;br /&gt;
|}&lt;br /&gt;
&lt;br /&gt;
=== Configuration Items ===&lt;br /&gt;
&lt;br /&gt;
=== Knowledge ===&lt;br /&gt;
&lt;br /&gt;
== See Also ==&lt;br /&gt;
[[Scoreboard]]&lt;br /&gt;
&lt;br /&gt;
[[Time-based Stored Queries]]&lt;/div&gt;</summary>
		<author><name>Erik.johnson</name></author>	</entry>

	<entry>
		<id>http://greggsmith.net/wiki/index.php?title=Lock_record&amp;diff=3920</id>
		<title>Lock record</title>
		<link rel="alternate" type="text/html" href="http://greggsmith.net/wiki/index.php?title=Lock_record&amp;diff=3920"/>
				<updated>2009-06-18T00:24:53Z</updated>
		
		<summary type="html">&lt;p&gt;Erik.johnson: New page: When an Analyst edits a ticket of any type, it locks that record for a determined period of time to ensure one person's changes don't overwrite another's. While this is a useful feature, i...&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;When an Analyst edits a ticket of any type, it locks that record for a determined period of time to ensure one person's changes don't overwrite another's. While this is a useful feature, it can be problematic when not set properly. If too short, someone might not be done editing the ticket, but if too long, it could remain locked for an extended period of time.&lt;br /&gt;
&lt;br /&gt;
To edit the lock time, edit the %NXROOT%\bopcfg\www\web.cfg file and search for &amp;quot;ExclLockSeconds&amp;quot;. Make sure there is not an exclamation mark preceding it, and put the number of seconds to lock the record after it.&lt;br /&gt;
&lt;br /&gt;
Example:&lt;br /&gt;
ExclLockSeconds 900&lt;br /&gt;
&lt;br /&gt;
After setting the variable as desired, you will need to rerun the Configure tool (pdm_configure) and restart services.&lt;/div&gt;</summary>
		<author><name>Erik.johnson</name></author>	</entry>

	</feed>