Григорий Ненашев (все сообщения)

Это на все 2000% кто-то залез в базу и руками изменил ID. Проходили уже.

А права есть админские?

Patch information

Title: Service Pack 35
Document ID: KM991685
Product: Service Desk
Version: 4.5
OS: Windows
Updated: 2010-Aug-30
Critical: No
Summary: ... General Release ... service desk 4.5 ... windows: nt4.00 xp 98 vista


» Register to receive e-mail notification about patch updates for Service Desk, 4.5, Windows
» Register to receive e-mail notification about patch updates Should I download?Download Link
DOWNLOAD PATCH
Product(s)
hp Openview service desk 4.5
Hardware platforms - OS releases
windows: nt4.00 xp 98 vista
Critical
NoNone
Summary
Change Request: ITSM009455
Reference check tool gives error on UI/DB rules
Change Request: ITSM009828
Provide support for Windows 2008
Change Request: ITSM009830
Client 2008 error: can not find labels.rep and
messages.rep at startup
Change Request: ITSM009834
Fail to login approval URL using non-ASCII characters as
password
Change Request: ITSM009835
Cannot cast Double to Float using generated API for
custom SLA percentage field
Change Request: ITSM009837
Can not set a value to the attribute 'Service Call' of
'Email Service Call'
Change Request: ITSM009838
Templates from drop-down menu do not set all fields from
the template
Change Request: ITSM009840
Error occurs when running 2 sd_dataform applications at
same time
Change Request: ITSM009842
Emails with attachment sent from SD miss body at cc
address
Change Request: ITSM009843
Web Console - Hidden fields are listed in Advanced Find

SR (service requests)
0000000000

Enhancement
No
Equivalent Patch
None
Installation InformationPatch dependencies
None
Hardware dependencies
None
Other dependencies
This service pack should only be used when
hp OpenView service desk 4.5 is installed.
Hot fixes will be removed during the installation
of this service pack.
Patch conflicts
None
Automatic reboot
NoInstallation instructions
Please review all instructions and the Hewlett-Packard
SupportLine User Guide or your Hewlett-Packard support terms
and conditions for precautions, scope of license,
restrictions, and, limitation of liability and warranties,
before installing this patch.
------------------------------------------------------------
1. Back up your system before installing a patch.

For installation instructions, please refer to the
install.htm file in the \\doc\install folder.

IMPORTANT NOTE:
In case one or more hot fixes are installed for hp
OpenView service desk 4.5 these hot fixes will be removed
during the installation of this service pack.
Special installation instructions
None




Скачать APP SP 35

Скачать Web Console SP 35

А найти связи можно поиском

Что-то найти не могу где указать как SLA считать через скрипт.... (как он считает пятницу до 5 или до 6)

Дополнения к посту 3

-- Добавление записи о сессии

CREATE TRIGGER [dbo].[DATA_UPDATE_USER]
ON [dbo].[REP_SESSIONS] FOR INSERT

AS

BEGIN
SET NOCOUNT ON;

declare @per_oid numeric(18,0)
declare @row as Int

set @per_oid = (select top 1 ITSM_PERSONS.PER_OID from inserted i
inner join ITSM_PERSONS ON i.SES_ACC_OID = ITSM_PERSONS.PER_ACC_OID)

set @row = (select count(*)
from ITSM_PER_CFT001 t1
where t1.ITSM_PER_CFT001_oid = @per_oid
and DateDiff(day, A0$_WORKDAY, getUTCDate()) = 0)

If (@row = 0) and (IsNull(@per_oid, 0) > 0)
begin
update ITSM_PER_CUSTOM_FIELDS
set PEC_PERSONDATE1 = getUTCDAte()
where PEC_PER_OID = @per_oid
-- and DateDiff(day, A0$_WORKDAY, getUTCDate())=0

insert into ITSM_PER_CFT001(ITSM_PER_CFT001_oid, A0$_WORKDAY, A0$_REG_PERS2, A0$_UNREG_PERS2)
values(@per_oid, cast(round(cast(getUtcDate() as float), 0, 1) as datetime), getUtcDate(), NULL)
end
END



_________________________________________



-- Удаление записи о сессии

CREATE TRIGGER [dbo].[REP_SESSIONS_D]

ON [dbo].[REP_SESSIONS]

FOR DELETE

AS

BEGIN

-- Update ITSM_PER_CUSTOM_FIELDS - время UnLogin
UPDATE ITSM_PER_CUSTOM_FIELDS
SET PEC_PERSONDATE2 = getUTCDate()
FROM deleted d
inner join ITSM_PERSONS ON ITSM_PERSONS.PER_ACC_OID = d.SES_ACC_OID
inner join ITSM_PER_CUSTOM_FIELDS as pe ON ITSM_PERSONS.PER_OID = pe.PEC_PER_OID
WHERE (d.SES_ACC_OID <> 1)

-- Update ITSM_PER_CFT001 - время UnLogin
update ITSM_PER_CFT001 set
A0$_UNREG_PERS2 = getUTCDate()
from deleted
inner join ITSM_PERSONS ON ITSM_PERSONS.PER_ACC_OID = deleted.SES_ACC_OID
inner join ITSM_PER_CFT001 ON ITSM_PERSONS.PER_OID = ITSM_PER_CFT001.ITSM_PER_CFT001_oid
and DateDiff(day, ITSM_PER_CFT001.A0$_WORKDAY, getUTCDate()) = 0

END


Структура таблицы журнала учёта рабочего времени в самом простейшем виде:

ВНИМАНИЕ данное поле создано в ручную из админки в SD (Поля менялись в ручную в базе после создания)

Key Colunm name Data type Length Allow nulls
3 Id_Journal int 4 0
0 ITSM_PER_CFT001_oid decimal 9 0
0 A0$_WORKDAY datetime 8 0
0 A0$_REG_PERS2 datetime 8 1
0 A0$_UNREG_PERS2 datetime 8 1


Дополнительно введено ключевое поле "Id_Journal", иначе с двойным ключём по полям ID и Дате сервисдеску было не по себе. Данный триггер доводил до ума
Виталий Сидоров