About MarcoGhiglieri

MarcoGhiglieri

Hi! You can customize this to your needs: SAS Help Center: About the Sample Code for Active Directory

MarcoGhiglieri · ‎03-14-2024

Saved me hours of work and buckets of tears. Thanks again for sharing!

MarcoGhiglieri · ‎03-13-2024

I feel it, I've found a number of customers installs with logins in General Servers. I tend to move them in dedicated selfnamed groups, then add the SAS General Servers as a member.

MarcoGhiglieri · ‎03-13-2024

I'd try a programmatic approach, i.e. to extract all the logins to check in which group/user it's in. I'm huge fan of Metacoda/ @PaulHomes work: %metacodaIdentityLoginExtract - Metacoda Identity Sync Utilities is a great tool code I'm always gratefull he shared. It happened I had to do it manually, but in very simple installations....

MarcoGhiglieri · ‎02-13-2024

Have you got any ACCESS module installed? The path is similar even you haven't one, this blog post could be usefull: Connecting SAS to a DB2 database via ODBC without tears - SAS Users .

MarcoGhiglieri · ‎02-08-2024

...Brilliant!

MarcoGhiglieri · ‎01-23-2024

AFAIK there's nothing working Out o the Box. For a similar audit activity, I put together some code to get users list, creation and last update dates from Metadata, and parse the Metadata server logs to get the last access timestamp. Never gone farther with groups.

MarcoGhiglieri · ‎12-21-2023

delete the hostname from shots...!

MarcoGhiglieri · ‎12-04-2023

Hi Deva, there's not such public documentation, at least not a "complete" one. Best practices are always the same: full "cold" backup, and procede by layers: upgrade LSF, then BackEnds (Meta and Compute tiers) and lastly FrontEnd (Web tier).

MarcoGhiglieri · ‎11-17-2023

Ciao Marco, IMHO a total reinstall is way better than fix this.

MarcoGhiglieri · ‎10-09-2023

I migrated a (**bleep** old) TS1M0 that was installed like a V8, so no MetadataServer, just a sort-of Connect Spawner to get remote sessions. It can be tricky to move from that to M8. I'd follow @SASKiwi advice and reach out SAS TCS or a Partner.

MarcoGhiglieri · ‎09-27-2023

Hi! You are mixing products/modules (SAS/Access, OR, STAT...) with solutions (SAS Office Analytics) which "incorporate" Studio. Maybe you can start tracking Web Logs to get some data - There's nothing ready out of the box, you'll have to enable and parse various logs.

MarcoGhiglieri · ‎09-12-2023

M0->M7/8 is quite a big jump, I've chosen multiple times the "new server, new life" way.

MarcoGhiglieri · ‎07-25-2023

I don't think it's related to licensing. Are you running on Linux or Windows? Did you install the PC Files Server? What's your code?

MarcoGhiglieri · ‎07-05-2023

Uhm... sasdev is the current hostname? If you ping it, can it be resolved to an IP address? That should be the IP of your host.

Online Status	Offline
Date Last Visited	3 weeks ago

Re: Batch update of SAS Metadata user ID's

Re: SAS 94 Management Console - Cant add Login. Userid already in use ...

Re: SAS 94 Management Console - Cant add Login. Userid already in use ...

Re: SAS 94 Management Console - Cant add Login. Userid already in use ...

Re: Installing odbc_cli driver for connecting to DB2 server in sas Li...

Re: User Login Report in SAS9.4

Re: Users last logon time

Re: Issue with WorkspaceServer while installing SAS9.4 M8

Re: How to Upgrade SAS Version from M7 to M8 in Grid Environment.

Re: SAS 9.4 M7 installation

Third-Party Security and Monitoring Software Disabling SAS Application...

Re: SAS 94 Management Console - Cant add Login. Userid already in use ...

Re: SAS 94 Management Console - Cant add Login. Userid already in use ...

Re: Unable to update the licenses

Re: Users last logon time

Re: SAS 94 Management Console - Cant add Login. Userid already in use ...

Re: SAS 94 Management Console - Cant add Login. Userid already in use ...

Re: How To Migrate data From SAS 9.4 TS1M0 to SAS 9.4 TS1M7?

Re: SAS Installation and SAS License

Re: SAS Admin Interview Questions for Exp Profile

Re: Batch update of SAS Metadata user ID's

Re: SAS 94 Management Console - Cant add Login. Userid already in use ...

Re: SAS 94 Management Console - Cant add Login. Userid already in use ...

Re: SAS 94 Management Console - Cant add Login. Userid already in use ...

Re: Installing odbc_cli driver for connecting to DB2 server in sas Li...

Re: User Login Report in SAS9.4

Re: Users last logon time

Re: Issue with WorkspaceServer while installing SAS9.4 M8

Re: How to Upgrade SAS Version from M7 to M8 in Grid Environment.

Re: SAS 9.4 M7 installation

Re: I Don't have SAS Metadata Server. What Do I Do?

Re: SAS products usage by who and when

Re: How To Migrate data From SAS 9.4 TS1M0 to SAS 9.4 TS1M7?

Re: SAS Installation and SAS License

Re: Unable to update SID on MetadataServer

SAS Analytics Explorers