Could you use the security setting for the Employee Role and Dispatch Console User? Documentation for 15.1 & 15.4 are the same. We use Dispatch Console User Security Settings (Page 86 in the 15.4 Dispatch Console User Guide) to lock most of the Console setting to Read only. Then use a security role to limit access to Service Orders
Thanks for promptly addressing this!
I do not have an API, but I do have a SQL script provided by Astea to manage the employee shifts. We run once a year. --US0009154 --Backup Table/* select * into person_shift_xref_bkup_20211110 from person_shift_xref *//* delete */select * from person_shift_xref where (effective_start_dt >='2008-01-01 00:00:00.000' and effective_end_dt <='2020-10-31 00:00:00.000') order by effective_start_dt/*delete from person_shift_xrefwhere (person_shift_xref.person_id in(select person_id from employee em where em.node_id='SG-PA') and person_shift_xref.effective_start_dt >='2008-01-01 00:00:00.000' and person_shift_xref.effective_end_dt <='2020-10-31 00:00:00.000')delete from person_shift_xrefwhere (effective_start_dt >='2008-01-01 00:00:00.000' and effective_end_dt <='2020-10-31 00:00:00.000') */
Maybe one option using SQLI had a similar experience with multiple Material requests from mobile user and needing all material requests in one email. I used the SQL stuff command to consolidate all material demands into one field.
Thanks for the prompt reply @Phil Seifert
If you are creating fields it woul be easy to set at that time. If you are wanting to change afterwards, I would suggest using Security Setup. It is a lot easier to manage than customizer.
Thanks Phil!! That would be the reason. The most obvious reason. We had vendor licenses and recently changed. Thanks everyone for information!!!!!!!
There is a table called gpsdata. The table is purged every so often and keeps the past 20 days based on your configuration editor setting.I use this data and order data to generate a SSRS report for management
You can use Process flows to changed the open/contract dates. We use the PM batch scheduler with floating PM dates. When the order is generated the open date is the date the PM is due. I use two process flows to set the open date to current date and set the contract date to the PM due date.I’ve attached the two process flows, if you want to import and see how I set them up. I have older workflow version as well.
Thanks GentlemenReid’s suggestion resolved the issue. There was one server patch (KB5026362) installed on May 11th
May I suggest for step 2, try using %UserProfile%\AppData\Local\Temp 😀
Big shout out to @Luis Aguero for jumping on this and keeping us informed. Thanks for the instructions and laughs! Fix deployed on servers.
If you have access to the database, here’s a query to only show the last time user logged in for the past 120 days select em.node_id,r.person_id,search_name,sa.sa_type_id,login_time,logout_time,client_machine_name,domain_user from (select asl.person_id,ps.search_name,asl.browser_version,asl.custom_version,'Y' as 'logged_in','' as logout_time,Convert(VarChar(10),asl.login_time,101)+' '+Convert(VarChar(5),asl.login_time,108)login_time, client_machine_name,domain_user,row_number() over(partition by asl.person_id order by asl.login_time desc) as rnfrom ap_session_log asljoin person ps on asl.person_id=ps.person_idwhere (ps.is_background = 'N' and asl.person_id <>'seal')and ps.is_employee ='Y'and ps.is_mobile_user <>'5'and ps.is_active='Y'and asl.login_time >= getdate()-120)rjoin employee em on r.person_id=em.person_idjoin sa on r.person_id=sa.person_idwhere rn = 1union select em.node_id,r.person_id,search_name,sa.sa_type_id,login_time,logout_time,client_machine_name,d
You could try the Data Dictionary in Alliance. I use a SQL query to quickly find the table(s) it is associated with it. SELECT t.name as 'Table', c.name FROM sys.tables tJOIN sys.columns c ON c.object_id = t.object_idWHERE c.name LIKE '%ccont_type%'order by c.name,t.name
Thanks, We are going to block the patch from our prod servers, and backup the config file. Unfortunately there is no way to know if Microsoft will do something similar on future patches
The key is avoiding the issue entirley. Either block the patch install, or modify the config file prior to deployment. I need to avoid potential production server outage.The KB article KB5022840 adds .msu to MIME Type. Your suggested fix avoids the issue by removing from config file. Should be safe to modify config file prior to patch.
Can this be done proactively before the MS patch is installed? Or should the patches be blocked from installing on servers? My UAT servers was impacted, but my production servers are schedule and not patched yet
We’ve used serialized consumable inventory from mobile for many years. I’m not aware of any MOE setting to prevent showing in mobile and agree with Phil about the Max Material Catalog. There is also a limit to the number of inventory items downloaded to mobile and if mobile users have the default warehouse set to a large depot/repair warehouse it may not show.
It looks correct. I tried your API in 15.1 and it worked
Thanks for the update
November is over two months away. I have HF12, and it will take 3-4 weeks to test before I would even consider installing in production. Plus the know bug with the Dispatch Console included in the release.
What is status for resolution? We have extrem tight SLA.
I’m on 15.1, and have HF12 release. HF12 has a know bug with the Dispatch Console date range. What is the status for HF13 release prior to November? If that’s not viable, can a Hotfix be released to address the bug in HF12?
Warehouse should be your Default Warehouse. This is a bug with the module and reported to support (US0066948@@1)
Yes, I do restrict access to specific pages, but it does not restrict imports in 15.1. Example I could restrict user access only to problem codes. User can still import problem codes from the import utiltiy.I’m very curious to see what the Web Employee Portal import ultitly has to offer. In 15.1, the server side import utility has more functionality. I can import using SQL script, and I can schedule import task to grab file from shared folder or SFTP server.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
