Maximo 7.2 => How to set Incident view to show only my site.

[pleza14]

Hi all,

I just starting to take maximo admin role and need your consult about Incident and SR module.
I have 2 sites in maximo then when my user each site create Incident/SR tickets they would like to see only their account in Incident/SR view. How to set it? 

Thank you for your advice. 

[Ethen]

well there are lot of ways to do it..
you can create two different security groups one for each site and attach this group to users. if user wants to access both sites SR, attach assign user to both security groups.

[Ethen]

or if you dont want to enforce it but just want to make convenience to users, but want that they should be able to see all sites records when they want it.

you can set a query for every user and make it default query in their profile.

[pleza14]

Hi Ethen

Thank you for your answers

For the first way is not work i have tried but for the second way, can you give me for the example of query because i don't know for query writing..
P.S. i want to separate Incident and SR witn each site. Others table can separate e.g PO, ASSET except incident and SR (TICKET table). please kindly advice me again.


Thank you very much..

[Ethen]

you can go to any application and click on advance query
there you enter the query 'say siteid='yoursite'' and save the query and make it your default query.

so whenever the user comes into that application his default query is loaded (all the records from siteid='yoursite'), although he can still see all other records by selecting all records from drop down in the left upper corner...

This doesnt put any restriction..

or you can put a restriction in the restriction tab in a security group like siteid='yoursite'. this way user can only fetch the records based on his site. This can be done in security groups application in restriction tab..(I am talkin about maximo 6 version.. you can check it in maximo 7)

[pleza14]

Hi Ethen,

Thanks you for your reply.

As your recommend I have to save query and i found error message that
"No records found that match the specified query"
The statement query is  status in (select value from synonymdomain where maxvalue in         ('INPROG','NEW','PENDING','QUEUED' ,'RESOLVED','SLAHOLD') and domainid in  ('INCIDENTSTATUS')) and siteid='yoursite'

is it correct?

Thanks

[Ethen]

why are u searching in the synonym domain..
query should look like
(siteid = 'HCM')

in the SR application

[pleza14]

Shall I set query every user? 

I have 2 sites and each site has user about 1000 users.

[Ethen]

well yeah... you have to..
Actually you have to create 2 queries and declare them as public queries. so they will be available to all users..

then for every user you have to insert the record in defaultquery table so it becomes their default query for application...

you can run a script to assign users their default queries..

[Today]

• How to get list data whic... by kvnaresh [Today at 12:39:03 am]
• How to change an email ad... by kvnaresh [Today at 12:25:57 am]
• Difference between fixpac... by jithu1989 [Yesterday at 05:25:18 am]
• Maximo Programmer Require... by ravikorukonda [February 06, 2012, 05:59:58 pm]
• Demo Maximo 7.1 Online by hyubby [February 06, 2012, 11:05:43 am]
• Error loading the Object ... by G Jeevan [February 06, 2012, 07:21:36 am]
• plzz attribute in another... by Dileep Kumar [February 06, 2012, 07:02:09 am]
• Jpeg attachments within M... by zenagarfield [February 02, 2012, 02:02:53 pm]
• How to change senders ema... by zenagarfield [February 02, 2012, 10:28:06 am]
• Lead and Crew by G Jeevan [February 02, 2012, 07:08:45 am]