Date: Thu, 10 Mar 2005 18:21:18 -0500
Reply-To: harry.droogendyk@RBC.COM
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Harry Droogendyk <harry.droogendyk@RBC.COM>
Subject: Re: directory listing with OWNER on W2K
Content-Type: text/plain; charset=iso-8859-1
Hmmmm.
I have the drive mapped locally and I can right-click in Windows Explorer and select "Owner" as a column I want to display, and as mentioned, I can run the code locally and it works fine. So it wouldn't be a security issue with MY userid.
However, remote submitted stuff will be running under whatever user the spawner is using, or whatever user the admin guys have specified the remote sessions to run under. I don't know what that userid is, or what its permissions are. I will ask the admin guys tomorrow.
I don't have terminal access to the server or admin privileges to do anything but signon / remote submit.
Thanks.
-----Original Message-----
From: Choate, Paul@DDS [mailto:pchoate@DDS.CA.GOV]
Sent: Thursday, March 10, 2005 6:17 PM
To: Droogendyk, Harry; SAS List (SAS-L@LISTSERV.UGA.EDU)
Subject: RE: directory listing with OWNER on W2K
Harry -
Pardon in advance my naiveté, but this isn't a permissions issue is it? Have you tried it as admin?
Paul Choate
DDS Data Extraction
(916) 654-2160
On Thu, 10 Mar 2005 17:09:48 -0500, Harry Droogendyk
<harry.droogendyk@RBC.COM> wrote:
>DOS Aficionados:
>
>I'm trying to pull a directory listing from a server drive, the same
server on which we remotely submit stuff that requires some horsepower.
When the server is stressed out, our SAS admin folks look around for remote
sessions to kill. By default, if it's older than today, they blow it
away. That's really unfortunate for guys like me that like to keep remote
sessions signed on for a day or two. Today two of my sessions disappeared,
work library entries etc... all gone.
>
>I want to give the admin guys a piece of code that will give them the
userids of those who own server work directories ( ie. from the remote
sessions )that haven't been touched since yesterday. If they key on the
corresponding remote sessions for only those work directories / userids, it
will hopefully reduce the frustration for some of us. ( They need userid
since the tool they use to surface the spawned SAS sessions shows sessions
by userid ).
>
>The /Q switch on the DIR command will surface the owner of the directory /
filename. However, when I try to remote submit the data step that reads
the directory listing through a pipe, all I get is 3 dots ( ie. ... ) where
the userid ought to show up. If I submit the code locally ( having the
server drive mapped locally as well ), it works fine. I've tried
adding 'command.com /c' and 'cmd.exe /c' before the 'dir' to force a
specific command processor. Only cmd.exe recognizes the /Q switch and it
returns the 3 dots as well.
>
>Yes, I could execute the code locally, but it takes two minutes to
retrieve the directory listing with the /Q switch ( only a couple seconds
without the switch ).
>
>Any ideas how I might have the remote submitted DIR command give me the
owner?
>
>Both local and remote machines are W2K running 8.2
>
>rsubmit;
> filename work pipe 'dir i:\ /o-d /ta /q';
>
> data accessed;
> infile work dlm= ' ';
> input date ?? mmddyy10. @;
> put _infile_;
> if n(date);
> input time : $6. _dir : $ owner : $20. workdir : $8. ;
> run;
>
> Volume in drive I is SAS3OCCAPP4
> Volume Serial Number is 9CAC-B1F3
> Directory of i:\
>03/09/2005 01:07p <DIR> ... _TD11136
>03/10/2005 12:41p <DIR> ... _TD1156
>
>Using the dinfo() function doesn't accomplish what I'm after since on
Windoze it returns nothing useful.
>
>TIA.
>
>------------------------------------------------------------
>
>This e-mail may be privileged and/or confidential, and the sender does not
waive any related rights and obligations. Any distribution, use or copying
of this e-mail or the information it contains by other than an intended
recipient is unauthorized. If you received this e-mail in error, please
advise me (by return e-mail or otherwise) immediately.
>
>Ce courrier électronique est confidentiel et protégé. L'expéditeur ne
renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion,
utilisation ou copie de ce message ou des renseignements qu'il contient par
une personne autre que le (les) destinataire(s) désigné(s) est interdite.
Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser
immédiatement, par retour de courrier électronique ou par un autre moyen.
>
>============================================================
------------------------------------------------------------
This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.
Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen.
============================================================
------------------------------------------------------------
This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.
Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen.
============================================================
| 
