This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
dear all,
i want to generate a query which tells that how many users are using maximo applications for example how many users are using PR , PO applications and also their rights information like read only , insert and save information.
your help required.
thanks
This should get you started..
SELECT groupuser.userid, maxgroup.groupname, sigoption.app, sigoption.description sigoptiondesc FROM groupuser JOIN maxgroup ON maxgroup.groupname=groupuser.groupname JOIN applicationauth ON applicationauth.groupname=maxgroup.groupname JOIN sigoption ON sigoption.optionname=applicationauth.optionname AND sigoption.app=applicationauth.app WHERE sigoption.app='YOURAPP' AND sigoption.description='YOURSIGOPTION' AND groupuser.userid='YOURUSER' ORDER BY groupuser.userid;
Shannon Sutton
Cell: (318) 334-8002
On Apr 12, 2013, at 5:12 AM, "Amir" <ashahzad.1978@yahoo.com> wrote:
> dear all,
>
> i want to generate a query which tells that how many users are using maximo applications for example how many users are using PR , PO applications and also their rights information like read only , insert and save information.
>
> your help required.
>
> thanks
>
>
Select a.groupname, g.description "Group Description", a.app, m.description "App Description", a.optionname, s.description "Option Description"
from MAXIMO.APPLICATIONAUTH a, MAXIMO.MAXGROUP g, maximo.maxapps m, maximo.sigoption s
where a.groupname = g.groupname
and a.app = m.app
and a.app = s.app
and a.app = 'xxx'
and a.optionname = s.optionname
order by a.groupname, a.app, a.optionname
Pat Morrow
pmorrow8@yahoo.com
________________________________
From: Yahoo <shannonsuttondale@yahoo.com>
To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
Sent: Friday, April 12, 2013 6:27 AM
Subject: Re: [MAXIMO List] query required how many users are using PR applications
This should get you started..
SELECT groupuser.userid, maxgroup.groupname, sigoption.app, sigoption.description sigoptiondesc FROM groupuser JOIN maxgroup ON maxgroup.groupname=groupuser.groupname JOIN applicationauth ON applicationauth.groupname=maxgroup.groupname JOIN sigoption ON sigoption.optionname=applicationauth.optionname AND sigoption.app=applicationauth.app WHERE sigoption.app='YOURAPP' AND sigoption.description='YOURSIGOPTION' AND groupuser.userid='YOURUSER' ORDER BY groupuser.userid;
Shannon Sutton
Cell: (318) 334-8002
On Apr 12, 2013, at 5:12 AM, "Amir" <mailto:ashahzad.1978%40yahoo.com> wrote:
> dear all,
>
> i want to generate a query which tells that how many users are using maximo applications for example how many users are using PR , PO applications and also their rights information like read only , insert and save information.
>
> your help required.
>
> thanks
>
>
Thanks a lot Pat Morrow for your prompt reply and help
--- In MAXIMO@yahoogroups.com, Pat Morrow <pmorrow8@...> wrote:
>
> Select a.groupname, g.description "Group Description", a.app, m.description "App Description", a.optionname, s.description "Option Description"
> from MAXIMO.APPLICATIONAUTH a, MAXIMO.MAXGROUP g, maximo.maxapps m, maximo.sigoption s
> where a.groupname = g.groupname
> and a.app = m.app
> and a.app = s.app
> and a.app = 'xxx'
> and a.optionname = s.optionname
> order by a.groupname, a.app, a.optionname
>
> Pat Morrow
> pmorrow8@...
>
>
>
> ________________________________
> From: Yahoo <shannonsuttondale@...>
> To: "MAXIMO@yahoogroups.com" <MAXIMO@yahoogroups.com>
> Sent: Friday, April 12, 2013 6:27 AM
> Subject: Re: [MAXIMO List] query required how many users are using PR applications
>
>
>
> Â
>
> This should get you started..
>
> SELECT groupuser.userid, maxgroup.groupname, sigoption.app, sigoption.description sigoptiondesc FROM groupuser JOIN maxgroup ON maxgroup.groupname=groupuser.groupname JOIN applicationauth ON applicationauth.groupname=maxgroup.groupname JOIN sigoption ON sigoption.optionname=applicationauth.optionname AND sigoption.app=applicationauth.app WHERE sigoption.app='YOURAPP' AND sigoption.description='YOURSIGOPTION' AND groupuser.userid='YOURUSER' ORDER BY groupuser.userid;
>
> Shannon Sutton
> Cell: (318) 334-8002
>
> On Apr 12, 2013, at 5:12 AM, "Amir" <mailto:ashahzad.1978%40yahoo.com> wrote:
>
> > dear all,
> >
> > i want to generate a query which tells that how many users are using maximo applications for example how many users are using PR , PO applications and also their rights information like read only , insert and save information.
> >
> > your help required.
> >
> > thanks
> >
> >
>
>
>
>
>
>
>
>
Thanks a lot Shannon , you people are more helpful than my expections
Best regards
Amir
--- In MAXIMO@yahoogroups.com, Yahoo <shannonsuttondale@...> wrote:
>
> This should get you started..
>
> SELECT groupuser.userid, maxgroup.groupname, sigoption.app, sigoption.description sigoptiondesc FROM groupuser JOIN maxgroup ON maxgroup.groupname=groupuser.groupname JOIN applicationauth ON applicationauth.groupname=maxgroup.groupname JOIN sigoption ON sigoption.optionname=applicationauth.optionname AND sigoption.app=applicationauth.app WHERE sigoption.app='YOURAPP' AND sigoption.description='YOURSIGOPTION' AND groupuser.userid='YOURUSER' ORDER BY groupuser.userid;
>
>
> Shannon Sutton
> Cell: (318) 334-8002
>
> On Apr 12, 2013, at 5:12 AM, "Amir" <ashahzad.1978@...> wrote:
>
> > dear all,
> >
> > i want to generate a query which tells that how many users are using maximo applications for example how many users are using PR , PO applications and also their rights information like read only , insert and save information.
> >
> > your help required.
> >
> > thanks
> >
> >
>
>
>
>
Dear All,
We have upgraded our environment from TSRM 7.2 to SCCD 7.5 and when we launch an
application which has data such as SR, Incidents, WO Tracking,assets etc, it is
displaying all records by default. There are no default queries set on any of
these applications
In our Pre-upgrade Environment (7.2) - No records are displayed when
one launches an application.
Does anyone have a fix/suggestion on how to get the applications not to list
records on launching?
Thank you,
Gimudah
SCCD 7.5.0.1
Websphere 7.0
OS -Windows Server 2008 R2
DB - SQL Server 2008 R2 10.0
Base Language:English
Browser: IE 8
Hi Gimudah,
We noticed the same thing after applying a patch for Maximo 7.5.0.3.
There is a fix in the 7.5.0.4 upgrade.
Look for IV28057 in the 7.5.0.4 APARs list here:
https://www.google.ca/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&cad=rja&ved=0CDwQFjAC&url=http%3A%2F%2Fwww-01.ibm.com%2Fsupport%2Fdocview.wss%3Fuid%3Dswg21620563%26aid%3D1&ei=j0ttUbf_Hs6i4AOJ5IH4BQ&usg=AFQjCNGV4VX3k3IFZxgGuGfQXx7q_fbmpA&sig2=guKzwp1BMF1Pd4q4gpuVBg&bvm=bv.45175338,d.dmg
That should also be available for SCCD as it uses the same TPAE core components.
In our case, we don't have much data and users yet but it could certainly affect users experience in certain apps such as Work Order Tracking. To revert to an empty list at app load, tick the startempty property in the table component of the list tab from the application designer app.
Jean-Pierre