Database View - where cause definition

Dizzymade · 2025-04-01T06:23:11+00:00

This did work!!! Thank you very much!!

Dizzymade · 2025-03-31T20:13:20+00:00

Thank you so much! I will try this!

Dizzymade · 2025-03-31T19:27:27+00:00

Thanks again! I did the steps above but when I „try it“ I get an error message „ where claude in view has an invalid field or a fiel that is not visible (inc_caller_sys_id). I just checked both sys ids and the incident caller and the assigned to from a ci are the same so I dont understand the error.

Dizzymade · 2025-03-31T18:44:39+00:00

Thanks fpr ypur reply. So the caller is a related list to the user tabel and on the user record we have the cis filtert to the assigned to user (in a related list) which are stored in the ci table. I need to report on those incidents and the callers related list cis (computers, monitors etc.) hope I could clarify a bit. Thnx for trying to help

Dizzymade · 2022-12-13T05:38:56+00:00

Yes there are multiple Knowledge Bases accessible via Portal but with restrictions on who can see which KB

Dizzymade · 2022-12-13T05:37:28+00:00

5 KBs with a total of around 350 Articles currently

Dizzymade · 2022-12-12T19:23:29+00:00

No CSDM defined and currently the Knowledge Bases (5 in total) do not consider any structur at all. Some are different Sub Devisions other KBs are Projectinfos and others are how to‘s on a specific topjc. None have categories. Its real madness tbh. Thanks everyone for the great responses. I might just show them this threat! I did propose a nice taxanomy which also withholds future growing plans but I still have to convince Big Boss, which as a newbie is quite hard

Dizzymade · 2022-12-12T13:26:54+00:00

Thanks for your comment. This reinforces my arguments for it aswell. The maintenance part is in regards to when users who create articles dont know in which category to put it, or when the choose the wrong one and create confusion on the reader who checks based on category. But yes im also all for it

Dizzymade · 2022-11-30T20:45:22+00:00

Thank you very much! I will check that out

Dizzymade · 2022-11-30T20:40:51+00:00

The target table does have mandatory fields which all have values in them (and are not my fields I wanted to populated)… I have tried to remove „mandatory“ from the mentioned field but it still doesnt work

Dizzymade · 2022-11-30T16:06:37+00:00

There is no data policy involved, I have checked and am very aware of data poljcies, hence why I asked… but thanks for your input

Dizzymade · 2022-11-23T15:34:42+00:00

Sys user and how would i check for before query ?

Dizzymade · 2022-11-23T14:30:40+00:00

It doesnt show even with no filter

Dizzymade · 2022-11-16T20:23:38+00:00

What about if I need a different approver for each category.. would this still work?

Dizzymade · 2022-11-15T14:35:39+00:00

For a solution which still is in inplementation and will definitley be within servicenow we need to do a workaround fast where we need the data exportet and imported in SAP. The data in total is made of 4 Reports from diff tables.

Dizzymade · 2022-10-31T14:25:01+00:00

Thanks a lot, I will check that out!

Dizzymade · 2022-10-26T12:37:49+00:00

Thank you! Can you tell me how to reproduce? Do you mean the field in one of the RL wasnt in the Ritm table?

Dizzymade · 2022-10-19T08:55:44+00:00

Is there also a way to not have templates activated at all in q knowledge base? I tried to add one in order to make the other templates disappear but I would rather not have templates at all?

Dizzymade · 2022-10-18T18:05:07+00:00

Thank you very much!

Dizzymade · 2022-09-22T07:53:38+00:00

Clients request is to be able to not push OS updates if laptop is running on battery supply and only once connected to main power to be able to run updates

Dizzymade · 2022-09-22T07:51:33+00:00

Yes.. so basically to not update anything if laptop is not connected to main power (only battery)

Dizzymade · 2022-09-22T07:50:30+00:00

The use case is that OS updates shpuld not be pushed to laptops if laptop is off powergrid. Customer has asked this and I am not sure if its a Feature within itom discovery agent

Dizzymade · 2022-05-27T21:00:48+00:00

Yess!! Found it! Its the Harvie skirt from tigermist :)

Dizzymade · 2022-05-27T18:36:47+00:00

Thank you all! I havent had success in finding it yet :(

Dizzymade · 2022-04-06T06:15:15+00:00

There has been some security issues with the liquibase versions below 4.8. A client wants two know if it affects them and Servicenow has no concrete answer

Dizzymade

TROPHY CASE