Re: [ActiveDir] OT: Know a good SMS list?
www.myitforum.com Best mailing list for SMS.! -- Sincerely, J On 1/3/07, Mike Guest <[EMAIL PROTECTED]> wrote: *Hi, sorry for the OT, but I got an issue and need some SMS help. If you know an SMS list which is as good as this one is for AD, please let me know. * I know there are some people on this list who are good with SMS, so I'll post an idea of my issue below. The answer may be simple, as I'm really a beginner in SMS – or may be impossible for all I know L We have a single SMS server serving clients on 4 sites, some of which are over slow links (yes, I know, not ideal) which they want to start deploying software from (it gets worse, doesn't it). The task I was given was that we use a preexisting replicated DFS structure to keep a copy of the install software, and expect AD site boundaries to ensure that clients pick up the files from the central location. I can't see any way in SMS to set up a remote distribution point (ie anywhere but the SMS box). Seems no matter what I try, the clients (all advanced) go back to the DP for the install files and not to the DFS (note, they use DFS strangely here, they use it as a single domain root replicating data between sites rather than using it to redirect users to shares on other servers) Is there any way to get a single SMS box to cause advanced clients to install an app from a fileshare local to them? Thanks in advance Mike Guest IT Solutions *HML *Padiham DDI: +44 (0)1282 682550 Internal Extension: (61) 2550 *** This email is intended only for the addressee named above. As this email may contain confidential or privileged information, if you are not the named addressee or receive this message in error, please notify us immediately, delete it and do not make use of or copy it. This message is protected by copyright. HML accepts no responsibility for viruses found in this message or any file attachment. Homeloan Management Limited Registered in England No. 2214839 1 Providence Place, Skipton, North Yorkshire BD23 2HL
Re: [ActiveDir] OT: M$
First thing my reference to Microsoft as M$, never thought it would offend someone. I have many friends in Microsoft and even during our personal e-mails I do reference Microsoft as M$ and none ever complained to me and I forwarded Laura's e-mail to them but then again everyone is not the same...anyways I never meant it in a negative way...and e-mail being an impersonal medium all I can do is type...
and if I offended someone I do apologise especially to Laura and other Microsoft employees who are offened by this symbol! :-)
-- Sincerely,J
On 11/13/06, Laura A. Robinson <[EMAIL PROTECTED]> wrote:
Clearly there are differing opinions about whether it's merely "slang" or whether it's an inappropriate slur. Simpler just not to use it, don't you think? I mean, I don't refer to the USAF as the "useless air farce" and expect its members to think that's funny.
I don't take offense when people refer to Microsoft as "borg" or talk about "drinking the Kool-Aid"; in fact, I have been known to reference both myself. However, I remember the origin of "M$" (unlike, I suspect, some of those who use the phrase and think it's funny), and I think it's ignorant and inappropriate for people to use it on a Microsoft-centric list.
Laura
From: [EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED]] On Behalf Of Bahta, Nathaniel V CTR USAF NASIC/SCNASent: Monday, November 13, 2006 5:48 AMTo:
ActiveDir@mail.activedir.orgSubject: RE: [ActiveDir] OT: M$
You have to be able to laugh at yourself. M$ is a tounge in cheek _expression_ and certainly a corporation like Microsoft can laugh at itself when M$ is used as slang in its reference. Thats why we nickname really big guys tiny.
From: [EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED]] On Behalf Of Albert DuroSent: Sunday, November 12, 2006 10:27 PMTo:
ActiveDir@mail.activedir.orgSubject: Re: [ActiveDir] OT: M$
being conciliatory is laudable, but I think you're missing the point. It's not wether anybody is offended or not -- the question is why does someone come into a peaceful gathering casting offense. Especially when it's not necessary. If someone deliberately spits on the dinner table, do you say 'oh, well, he didn't hit any plate, let's just forget it' ? or even worse, 'he hit someone else's plate -- no worries.'
- Original Message -
From: [EMAIL PROTECTED]
To: ActiveDir@mail.activedir.org
Sent: Friday, November 10, 2006 9:08 AM
Subject: RE: [ActiveDir] OT: M$
I highly doubt that any MS employee takes offence at what is surely as tongue in cheek _expression_.
Let's not get _too_ PC please :/
neil
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
Laura A. RobinsonSent: Thursday, November 09, 2006 6:14 PMTo: ActiveDir@mail.activedir.org
Subject: [ActiveDir] OT: M$
Just out of curiosity, what makes people think it's appropriate to refer to Microsoft as "M$" on an MS-focused mailing list whose participants include Microsoft employees, Microsoft contractors, Microsoft MVPs and various other people who may have a relatively positive view of Microsoft?
Laura
From: [EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED]] On Behalf Of Jitendra KalyankarSent: Thursday, November 09, 2006 10:16 AMTo:
ActiveDir@mail.activedir.orgSubject: Re: [ActiveDir] Beginner's Book on Scripting - WSH or _vbscript_?
This is the link to M$ to start with...very good info
http://msdn.microsoft.com/library/default.asp?url=""
-- Sincerely,J
On 11/9/06, Stu Packett <[EMAIL PROTECTED]
> wrote:
Hello everyone. After reading through a lot of the posts on this mailing list, I realize I could make my job easier if I knew how to script. I have no experience in scripting, but would like to know what books do you recommend as a beginner's book on scripting? Also, I don't really know the difference between WSH and _vbscript_, so if anyone could explain that, I'd appreciate that. After browsing through Amazon, I saw several books on WSH and _vbscript_, but don't know where I should focus on. I'm also open to computer based training (CBT) videos of any exist. Thanks in advance.
PLEASE READ: The information contained in this email is confidential and
intended for the named recipient(s) only. If you are not an intended
recipient of this email please notify the sender immediately and delete your
copy from your system. You must not copy, distribute or take any further
action in reliance on it. Email is not a secure method of communication and
Nomura International plc ('NIplc') will not, to the extent permitted by law,
accept responsibility or liability for (a) the accuracy or completeness of,
or (b) the presence of any virus, worm or similar malicious or disabling
code in, this message or any attachment(s) to it. If verification of this
email is sought then please request a hard copy. Unless otherwise stated
this email: (1) is not, and should not be treated or relied upon as,
investment research; (2) contains views
Re: [ActiveDir] Beginner's Book on Scripting - WSH or VBScript?
This is the link to M$ to start with...very good info http://msdn.microsoft.com/library/default.asp?url=""> -- Sincerely,J On 11/9/06, Stu Packett <[EMAIL PROTECTED]> wrote: Hello everyone. After reading through a lot of the posts on this mailing list, I realize I could make my job easier if I knew how to script. I have no experience in scripting, but would like to know what books do you recommend as a beginner's book on scripting? Also, I don't really know the difference between WSH and _vbscript_, so if anyone could explain that, I'd appreciate that. After browsing through Amazon, I saw several books on WSH and _vbscript_, but don't know where I should focus on. I'm also open to computer based training (CBT) videos of any exist. Thanks in advance.
Re: [ActiveDir] Asset Inventory (OT)
I would say SMS 2003 SP1 & SP2 is much better product if you know/worked with previous versions of SMS (1.2 & 2.0). Being said that I would not say it has all the feature you will need if you need only inventory then I would say go some other way like Joe (and everyone else mentioned). I can write a long mail because I am managing SMS infrastructure in my company but then again whatever works for my company may not work for yoursmy $0.02! If anyone wants any help w.r.t. SMS 2003 mail me offline! ;-) -- Sincerely J On 5/2/06, joe <[EMAIL PROTECTED]> wrote: Voice of reason!Exactly, the same things being said about SMS could have been said aboutTivoli and several other "Frameworks". If all that is wanted/needed is inventory, there is nothing bad aboutputting together a small scripted system to do it. It is targeted, it iseasier to troubleshoot when it doesn't work, and you have full control over it. Even getting the agents out there is not difficult if you plan for it inyour design, what SMS and other frameworks do for agent deployment is notrocket science and it doesn't all have to be in a home brew or "roll your own" solution immediately.Now the flip side of the coin What do want to do down the road? Thepoint at which the frameworks start making sense is when you start doing allsorts of automation such as inventory and software delivery and this and that and some of the other. Then you don't have to invent new solutions foreach. You could always build out your custom solution to be a framework butat that point, you have to weigh in how long it would take to do in some other framework that already exists. That is tough to do because certainly,with none of the big products is it usually a simple slap it out there andit works unless you have a tiny little configuration that probably can easily survive without it. I have said it before and I will say it again andagain that MSFT's scaling often has issues, especially around management,there is a lot of if it works for one, then the admins should be able to figure out how to do it for thousands even if we don't make it very possiblefor them.Oh one of the big issues I tend to have with the massive frameworks (andmonitoring systems). They all usually want to run with domain admin (or localsystem on every machine including DCs) rights, especially if they areautomatically discovering and deploying themselves. This means severalthings, such as huge possible security hole and you can't delegate them off. It is another task that domain admins have to be in full control of. If yougive someone else the permissions to run it, then you have just effectivelymade them domain admins as well. I find that unacceptable and would build every other solution from the ground up to avoid it until the vendorsactually get it through their head, yes including MSFT, that people wanttruly secure systems. Again, this isn't an issue in small environments where the domain admin is already responsible for everything, but again, in thoseplaces, the frameworks have limited use and life is difficult but definitelypossible without them so the need isn't as great as in a large deployment where delegation of support tasks is required.joe--O'Reilly Active Directory Third Edition -http://www.joeware.net/win/ad3e.htm -Original Message-From: [EMAIL PROTECTED][mailto:[EMAIL PROTECTED] ] On Behalf Of Darren Mar-EliaSent: Tuesday, May 02, 2006 1:05 AMTo: ActiveDir@mail.activedir.orgSubject: RE: [ActiveDir] Asset Inventory (OT)"SMS is one of those products you get out of it what you put into it." Hehe, can't resist--yes, you put 50 dedicated admins into it and you have 50dedicated admins that want to get out of it :)My experiences span SMS 1.x, 2.x and not so much with the latest version.I've also had lots of experience with a variety of other sw. distribution/inventory tools. If all you want is inventory, then I think SMSis overkill. Its overly complex and does require a lot of work to make it dowhat you want in an ongoing fashion. There are other strictly asset management or configuration management-based tools that do just that and doit well. Some that come to mind include Configuresoft, StealthBits, etc.Darren-Original Message-From: [EMAIL PROTECTED][mailto:[EMAIL PROTECTED]] On Behalf Of Tim SullivanSent: Monday, May 01, 2006 9:52 PMTo: ActiveDir@mail.activedir.orgSubject: RE: [ActiveDir] Asset Inventory (OT)SMS 2003 is light years different than 1.2 or even 2.0. Its certainly worthanother evaluation, especially with feature packs like Operating System Deployment and Mobile Device management packs.SMS is one of those products you get out of it what you put into it.Tim-Original Message-From: [EMAIL PROTECTED][mailto:[EMAIL PROTECTED]] On Behalf Of Timo EdSent: Monday, May 01, 2006 11:36 PMTo: ActiveDir@mail.activedir.orgSubject: Re: [ActiveDir] Asset Inventory (OT)Brian, I cannot comment on the latest versions of SMS, but I can say that Iwas extremely unimpres
Re: [ActiveDir] OT: Any Programming courses for Systems Administrators?
active directory for one On 2/8/06, Krenceski, William <[EMAIL PROTECTED]> wrote: Depends on the systems. Bill K From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Jitendra KalyankarSent: Wednesday, February 08, 2006 1:04 PMTo: ActiveDir@mail.activedir.orgSubject: [ActiveDir] OT: Any Programming courses for Systems Administrators? I need to know if there are any programming courses are specifically oriented for Systems Administrator. If not what will be the best thing to learn? Please let me know...-- Sincerely,J Confidentiality Notice: The information contained in this message may be legally privileged and confidential information intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any release, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error please notify the author immediately by replying to this message and deleting the original message. Thank you. -- Thanks,Jitendra Kalyankar
[ActiveDir] OT: Any Programming courses for Systems Administrators?
I need to know if there are any programming courses are specifically oriented for Systems Administrator. If not what will be the best thing to learn? Please let me know...-- Sincerely,J
Re: [ActiveDir] Need Script.
If at all if you write a special invoice please make sure to give me some
percentage in that! ;-) I have been marketing them whole heartedly!
Sincerely,
J
On 2/3/06, joe <[EMAIL PROTECTED]> wrote:
What I really need to do is start kicking out tools I charge for. :o)
I wouldn't mind getting to a point where enough income was coming in that I could just play around working out new tools all day.
--
O'Reilly Active Directory Third Edition -
http://www.joeware.net/win/ad3e.htm
From: [EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED]] On Behalf Of Noah EigerSent: Friday, February 03, 2006 12:12 AM
To: ActiveDir@mail.activedir.orgSubject:
RE: [ActiveDir] Need Script.
Joe, maybe you should write a special invoice for
Jitendra's company ;-)
From: joe [mailto:
[EMAIL PROTECTED]] Sent: Thursday, February 02, 2006 8:38 PM
To: ActiveDir@mail.activedir.org
Subject: RE: [ActiveDir] Need Script.
Quite honestly this isn't the first time I have heard this. Many companies have an unnatural aversion to products that are free. They want to know what the catch is and they think that just because they pay for something they are getting better support. Of course that simply means they aren't really reading those EULAs. :)
--
O'Reilly Active Directory Third Edition -
http://www.joeware.net/win/ad3e.htm
From:
[EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED]] On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, February 02, 2006 6:51 AMTo:
ActiveDir@mail.activedir.orgSubject: RE: [ActiveDir] Need Script.
So Joe's excellent utilities are banned yet you're able to accept a script from someone else??? How does that work?? Which options offers the highest risk and which offers robustness and maturity? You choose :)
neil
From:
[EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED]] On Behalf Of Jitendra KalyankarSent: 02 February 2006 11:31
To: ActiveDir@mail.activedir.orgSubject:
[ActiveDir] Need Script.
Good Morning guys!
I need a script to locate bulk users from a text file and put it in a csv file
I know that Joe's tool would do this, but as I mentioned in my earlier
mails it can not be used in my organisation.
:-(
Have a wonderful Thursday!
Sincerely,
J
PLEASE READ: The information contained in this email is confidential and
intended for the named recipient(s) only. If you are not an intended
recipient of this email please notify the sender immediately and delete your
copy from your system. You must not copy, distribute or take any further
action in reliance on it. Email is not a secure method of communication and
Nomura International plc ('NIplc') will not, to the extent permitted by law,
accept responsibility or liability for (a) the accuracy or completeness of,
or (b) the presence of any virus, worm or similar malicious or disabling
code in, this message or any attachment(s) to it. If verification of this
email is sought then please request a hard copy. Unless otherwise stated
this email: (1) is not, and should not be treated or relied upon as,
investment research; (2) contains views or opinions that are solely those of
the author and do not necessarily represent those of NIplc; (3) is intended
for informational purposes only and is not a recommendation, solicitation or
offer to buy or sell securities or related financial instruments. NIplc
does not provide investment services to private customers. Authorised and
regulated by the Financial Services Authority. Registered in England
no. 1550505 VAT No. 447 2492 35. Registered Office: 1 St Martin's-le-Grand,
London, EC1A 4NP
. A member of the Nomura group of companies.
--No virus found in this incoming message.Checked by AVG Free Edition.Version: 7.1.375 / Virus Database: 267.14.25/247 - Release Date: 1/31/2006
--No virus found in this outgoing message.Checked by AVG Free Edition.Version: 7.1.375 / Virus Database: 267.14.25/247 - Release Date: 1/31/2006
Re: [ActiveDir] Need Script.
I will forward this to my manager! :D
I am using it (don't tell this to my manager) but I don't want to
give it to someone else...you know how it works...
Sincerely,
J
On 2/2/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]
> wrote:
So Joe's excellent utilities are banned yet you're able to accept a script from someone else??? How does that work?? Which options offers the highest risk and which offers robustness and maturity? You choose :)
neil
From: [EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED]] On Behalf Of Jitendra KalyankarSent: 02 February 2006 11:31To:
ActiveDir@mail.activedir.orgSubject: [ActiveDir] Need Script.
Good Morning guys!
I need a script to locate bulk users from a text file and put it in a csv file
I know that Joe's tool would do this, but as I mentioned in my earlier
mails it can not be used in my organisation.
:-(
Have a wonderful Thursday!
Sincerely,
J
PLEASE READ: The information contained in this email is confidential and
intended for the named recipient(s) only. If you are not an intended
recipient of this email please notify the sender immediately and delete your
copy from your system. You must not copy, distribute or take any further
action in reliance on it. Email is not a secure method of communication and
Nomura International plc ('NIplc') will not, to the extent permitted by law,
accept responsibility or liability for (a) the accuracy or completeness of,
or (b) the presence of any virus, worm or similar malicious or disabling
code in, this message or any attachment(s) to it. If verification of this
email is sought then please request a hard copy. Unless otherwise stated
this email: (1) is not, and should not be treated or relied upon as,
investment research; (2) contains views or opinions that are solely those of
the author and do not necessarily represent those of NIplc; (3) is intended
for informational purposes only and is not a recommendation, solicitation or
offer to buy or sell securities or related financial instruments. NIplc
does not provide investment services to private customers. Authorised and
regulated by the Financial Services Authority. Registered in England
no. 1550505 VAT No. 447 2492 35. Registered Office: 1 St Martin's-le-Grand,
London, EC1A 4NP. A member of the Nomura group of companies.
[ActiveDir] Need Script.
Good Morning guys! I need a script to locate bulk users from a text file and put it in a csv file I know that Joe's tool would do this, but as I mentioned in my earlier mails it can not be used in my organisation. :-( Have a wonderful Thursday! Sincerely, J
Re: [ActiveDir] Script to find Computers under particular OUs
Okay I got it. I will script as you mentioned in your second para. I know I can count on you guys Sincerely, J On 12/20/05, joe <[EMAIL PROTECTED]> wrote: Writing it this way is very inefficient. It would take x queries to look for each computer where X is the number of OUs you want to check since you can't tell AD "look only in these distinct OUs" unless you can specify one single branch of the hierarchy that contains all of the OUs. As you add more OUs in different branches, the script would get slower and slower. It would be much more efficient to query the computer and then compare the DN of the computer to the OUs you are interested in. That way most of the work is string comparison on the machine running the script. Another possible method would be to return all computer DNs for computers in the listed OUs and then compare those with string comparison to the computers you have. This could have implications on your memory allocation though if there are ALOT of machines in those OUs. For instance, say you have 1000 computers to be checked against 10 OUs in diseparate branches. The initial method you indicate would require 10,000 queries. The first method I mentioned would require 1000 queries. The second method I mentioned would take 10 queries but would probably require more RAM. From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Jitendra KalyankarSent: Tuesday, December 20, 2005 11:10 AMTo: ActiveDir@mail.activedir.orgSubject: [ActiveDir] Script to find Computers under particular OUs I am trying to find a way to write script. The scenario is a bit like this, I have few OU under which there are Computers. I need to check if computer names are supplied from the text file then it will have to run against those particular OUs. If it can find machine under those particular OUs then it will write something like found or not found depending upon the search result. I know how to query against entire AD but I am looking a way out where I can just supply or hardcode the OUs and it will search against those multiple OUs only and not entire AD. Any help in this regard is much appreciated. Sincerely, J -- Thanks,Jitendra Kalyankar
Re: [ActiveDir] Script to find Computers under particular OUs
_vbscript_ing would be great. I can do the dump of entire AD but just want to know how to script for particular set of OUs. Sincerely, J On 12/20/05, Creamer, Mark <[EMAIL PROTECTED]> wrote: Wouldn't it be faster/more efficient to search for all computer objects and output the entire distinguishedname (which would obviously include the ou name)? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jitendra KalyankarSent: Tuesday, December 20, 2005 11:10 AMTo: ActiveDir@mail.activedir.orgSubject: [ActiveDir] Script to find Computers under particular OUs I am trying to find a way to write script. The scenario is a bit like this, I have few OU under which there are Computers. I need to check if computer names are supplied from the text file then it will have to run against those particular OUs. If it can find machine under those particular OUs then it will write something like found or not found depending upon the search result. I know how to query against entire AD but I am looking a way out where I can just supply or hardcode the OUs and it will search against those multiple OUs only and not entire AD. Any help in this regard is much appreciated. Sincerely, J This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated. -- Thanks,Jitendra Kalyankar
[ActiveDir] Script to find Computers under particular OUs
I am trying to find a way to write script. The scenario is a bit like this, I have few OU under which there are Computers. I need to check if computer names are supplied from the text file then it will have to run against those particular OUs. If it can find machine under those particular OUs then it will write something like found or not found depending upon the search result. I know how to query against entire AD but I am looking a way out where I can just supply or hardcode the OUs and it will search against those multiple OUs only and not entire AD. Any help in this regard is much appreciated. Sincerely, J
Re: [ActiveDir] W2K & W2K3 environment.
Company is large and distributed across the globe in around 66 countries. Here is other thing, I just joined the team about say 3 months back and found out many things that need urgent attention to state a few, first was replication which right now is fixed. Not perfect but working okay for the time being. Second is DNS which is a *nix based DNS. What will be the solution for this problem, I can setup a Windows DNS and/or I can put a Read-Only Windows DNS inside each big site. The list of problems can go on and on. Anyways I have same opinion that we need to fix the current infrastructure first, but making sure that my reasoning is correct. Sincerely, J On 12/14/05, Mike Williams <[EMAIL PROTECTED]> wrote: We went through that a while back. If your current environment is not running properly group policies won't apply correctly. They will be hit and miss as to which workstations they apply to. AD problems usually track back to DNS problems Fix your current problems first.. Mike -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jitendra KalyankarSent: Wednesday, December 14, 2005 10:39 AMTo: ActiveDir@mail.activedir.orgSubject: [ActiveDir] W2K & W2K3 environment. Here is scenario that is currently being played in my company. We have W2K AD in place, we are not using GPOs except one or two. Now suddenly they (read managers) realized that we need to implement GPO extensively. There are issues with current AD infrastructure like replication is not proper, DNS etc. And other thing is my company has at least 12 different language that we have to support on Windows XP OS. Now there are two groups in company one is saying go for fixing the existing infrastructure and second is saying go for W2K3 since the W2K is almost non-existant. My question to list is what would you suggest in this situation. Any insights, inputs are more than welcome. Also I will keep posted about the decision we (read managers) make, we are having a meeting with Microsoft for this but just as heads up I need to understand obvious pitfalls if any. -- Sincerely,Jitendra Kalyankar
[ActiveDir] W2K & W2K3 environment.
Here is scenario that is currently being played in my company. We have W2K AD in place, we are not using GPOs except one or two. Now suddenly they (read managers) realized that we need to implement GPO extensively. There are issues with current AD infrastructure like replication is not proper, DNS etc. And other thing is my company has at least 12 different language that we have to support on Windows XP OS. Now there are two groups in company one is saying go for fixing the existing infrastructure and second is saying go for W2K3 since the W2K is almost non-existant. My question to list is what would you suggest in this situation. Any insights, inputs are more than welcome. Also I will keep posted about the decision we (read managers) make, we are having a meeting with Microsoft for this but just as heads up I need to understand obvious pitfalls if any. -- Sincerely,Jitendra Kalyankar
[ActiveDir] OT: Importing multiple CSV files in Access Table
Hello there! Does anyone have some code snippet and\or script that I can use to import CSV files to import to Access table. I need to import around 200 CSV files with all different names to one particular table. Thanks in advance guys.Sincerely, Jitendra Kalyankar
Re: [ActiveDir] ADSI Scripting - How to find Computer's OU.
Thanks Bob! This works for me!
On 11/16/05, Free, Bob <[EMAIL PROTECTED]> wrote:
> Disclaimer- I am not a programmer nor do I play one on TV but this works
> for me. I am sure someone can pick it apart and tell me how dumb I am
> but hey, it works for me :-p
>
> It will default to local host and domain but prompt for either. Replace
> xyz with the default domain of choice.
>
> ' simple script to display LDAP path / DN rwf4-12:57 PM 3/11/2004
>
> Set Network = WScript.CreateObject("WScript.Network")
>
> compname = InputBox ("Enter NETBIOS name of computer - Default is local
> machine", "GetComputerLocation In AD", Network.ComputerName )
>
> domname = InputBox ("Enter name of domain- Default is xyz",
> "GetDomainName", "XYZ")
>
> Set oNet = CreateObject("Wscript.Network")
> Set oTrans = CreateObject("NameTranslate")
> oTrans.Init 1, domname
> oTrans.Set 3, domname &"\"& compname &"$"
> sAdsPath = oTrans.Get(1)
> Set oNet = Nothing
> Set oTrans = Nothing
> wscript.echo "Computer Location in AD: " & sAdsPath
>
>
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Jitendra
> Kalyankar
> Sent: Wednesday, November 16, 2005 12:55 PM
> To: ActiveDir@mail.activedir.org
> Subject: Re: [ActiveDir] ADSI Scripting - How to find Computer's OU.
>
> This is to check for local computer. What will be the method to check it
> against the remote computers. I have a InputBox in the program which
> takes input from user, using that string value I want to determine the
> OU
> of remote computer.
>
> Please let me know if you can shed some light on this.
>
> Thank again,
> Jitendra Kalyankar
>
> On 11/16/05, Jitendra Kalyankar <[EMAIL PROTECTED]> wrote:
> > Thanks much that is helpful
> >
> > Jitendra Kalyankar
> > On 11/16/05, Tomasz Onyszko <[EMAIL PROTECTED]> wrote:
> > > Jitendra Kalyankar wrote:
> > > > I need your guidance to write the script. I need to find out
> > > > name of the OU to which the computer account belongs.
> > > > Let me know how you can find it.
> > > >
> > >
> http://groups.google.com/group/microsoft.public.scripting.vbscript/brows
> e_thread/thread/fa91247b1a4d65ba/1058b6ce8cad2cfe?lnk=st&q=determine+com
> puter+OU+vbscript&rnum=1&hl=en#1058b6ce8cad2cfe
> > >
> > > --
> > > Tomasz Onyszko
> > > http://www.w2k.pl
> > > List info : http://www.activedir.org/List.aspx
> > > List FAQ: http://www.activedir.org/ListFAQ.aspx
> > > List archive:
> http://www.mail-archive.com/activedir%40mail.activedir.org/
> >
>
>
> --
> Thanks,
> Jitendra Kalyankar
> List info : http://www.activedir.org/List.aspx
> List FAQ: http://www.activedir.org/ListFAQ.aspx
> List archive:
> http://www.mail-archive.com/activedir%40mail.activedir.org/
>
> List info : http://www.activedir.org/List.aspx
> List FAQ: http://www.activedir.org/ListFAQ.aspx
> List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
List info : http://www.activedir.org/List.aspx
List FAQ: http://www.activedir.org/ListFAQ.aspx
List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
Re: [ActiveDir] ADSI Scripting - How to find Computer's OU.
This is to check for local computer. What will be the method to check it against the remote computers. I have a InputBox in the program which takes input from user, using that string value I want to determine the OU of remote computer. Please let me know if you can shed some light on this. Thank again, Jitendra Kalyankar On 11/16/05, Jitendra Kalyankar <[EMAIL PROTECTED]> wrote: > Thanks much that is helpful > > Jitendra Kalyankar > On 11/16/05, Tomasz Onyszko <[EMAIL PROTECTED]> wrote: > > Jitendra Kalyankar wrote: > > > I need your guidance to write the script. I need to find out > > > name of the OU to which the computer account belongs. > > > Let me know how you can find it. > > > > > http://groups.google.com/group/microsoft.public.scripting.vbscript/browse_thread/thread/fa91247b1a4d65ba/1058b6ce8cad2cfe?lnk=st&q=determine+computer+OU+vbscript&rnum=1&hl=en#1058b6ce8cad2cfe > > > > -- > > Tomasz Onyszko > > http://www.w2k.pl > > List info : http://www.activedir.org/List.aspx > > List FAQ: http://www.activedir.org/ListFAQ.aspx > > List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ > -- Thanks, Jitendra Kalyankar List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
Re: [ActiveDir] ADSI Scripting - How to find Computer's OU.
Thanks much that is helpful Jitendra Kalyankar On 11/16/05, Tomasz Onyszko <[EMAIL PROTECTED]> wrote: > Jitendra Kalyankar wrote: > > I need your guidance to write the script. I need to find out > > name of the OU to which the computer account belongs. > > Let me know how you can find it. > > > http://groups.google.com/group/microsoft.public.scripting.vbscript/browse_thread/thread/fa91247b1a4d65ba/1058b6ce8cad2cfe?lnk=st&q=determine+computer+OU+vbscript&rnum=1&hl=en#1058b6ce8cad2cfe > > -- > Tomasz Onyszko > http://www.w2k.pl > List info : http://www.activedir.org/List.aspx > List FAQ: http://www.activedir.org/ListFAQ.aspx > List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
[ActiveDir] ADSI Scripting - How to find Computer's OU.
I need your guidance to write the script. I need to find out name of the OU to which the computer account belongs. Let me know how you can find it. Thanks in advance for your help. -- Thanks, Jitendra Kalyankar List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
Re: [ActiveDir] Need ADSI Scripting help.
Thanks much I really appreciate your help!
Thanks again,
Jitendra Kalyankar
On 10/24/05, AD <[EMAIL PROTECTED]> wrote:
>
>
> Assuming file containing computer names is Computers.txt located in the same
> folder as vbs. This creates an outputfile called "Computers – Results.txt".
> You can add any attributes to your outputfile as needed.
>
>
>
> ' Start of Script
>
> Option Explicit
>
>
>
> ' Objects
>
> Dim oFS
>
> Dim oInputFile
>
> Dim oOutputFile
>
> Dim rootDSE
>
> Dim objConnection
>
> Dim objCommand
>
> Dim objRecordSet
>
> Dim rsComputers
>
>
>
> ' Arrays
>
> Dim aComputers
>
>
>
> ' Strings
>
> Dim sComputer
>
> Dim sDomain
>
> Dim sStatus
>
>
>
> Set oFS = CreateObject("Scripting.FileSystemObject")
>
> Set oInputFile = oFS.OpenTextFile("Computers.txt", 1)
>
> Set oOutputFile = oFS.CreateTextFile("Computers - Result.txt", True)
>
>
>
> ' Doing AD Stuff
>
> Set rootDSE = GetObject("LDAP://RootDSE")
>
> sDomain = rootDSE.Get("defaultNamingContext")
>
> Set objConnection = CreateObject("ADODB.Connection")
>
> Set objCommand = CreateObject("ADODB.Command")
>
> objConnection.Provider = "ADsDSOObject"
>
> objConnection.Open "Active Directory Provider"
>
> Set objCOmmand.ActiveConnection = objConnection
>
> objCommand.Properties("Page Size") = 1000
>
> objCommand.properties("Cache Results") = True
>
>
>
> ' Reading Text File
>
> aComputers = Split(oInputFile.ReadAll, VbCrLf)
>
>
>
> ' looping every computer
>
> For Each sComputer In aComputers
>
>
>
> objCommand.CommandText = " ">;(&(objectcategory=computer)(cn=" & sComputer & "));Name,
> userAccountControl;Subtree"
>
> Set rsComputers = objCommand.Execute
>
>
>
> If rsComputers.EOF Then
>
> oOutputFile.WriteLine sComputer& vbTab &
> "Can't find computer"
>
> Else
>
> Do Until rsComputers.EOF
>
>
>
> If
> rsComputers.Fields("userAccountControl").value And 2 Then
>
> sStatus = "Disabled"
>
> Else
>
> sStatus = "Enabled"
>
> End if
>
>
>
> oOutputFile.WriteLine sComputer & vbTab &
> sStatus
>
>
>
> rsComputers.MoveNext
>
> Loop
>
> End if
>
> Next
>
>
>
> ' Closing Text file
>
> oInputFile.Close
>
> oOutputFile.Close
>
> objConnection.Close
>
>
>
> ' End of Script
>
>
>
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Kamlesh Parmar
> Sent: Friday, October 21, 2005 5:10 PM
> To: ActiveDir@mail.activedir.org
> Subject: Re: [ActiveDir] Need ADSI Scripting help.
>
>
>
>
> I was hoping someone will direct him to dsquery :o)
>
> Assuming file containing computernames is Comps.txt
>
> put this in the batch file and keep it in same folder as comps.txt
>
> for /f %%A in (comps.txt) do (
> dsquery computer -samid %%A$ | dsget computer -samid -disabled
> )
>
> You should get the two column listing computername with YES or NO for
> disabled.
>
> -
> Kamlesh
>
>
> On 10/21/05, Jitendra Kalyankar <[EMAIL PROTECTED] > wrote:
>
> I know about the Oldcmp.exe, but the thing is the tool is really
> powerful and I don't want Jr. Sys. Admins doing something or
> deleting something that they are not suppose to. And again
> I will have to go through the security department route to use
> it. Too much hassel
>
> Hope that explains my situation.
>
> Sincerely,
> Jitendra Kalyankar
>
> On 10/20/05, Creamer, Mark <[EMAIL PROTECTED]> wrote:
> > Before you do this, see oldcmp at www.joeware.net
> >
> > http://www.joeware.net/win/free/index.htm
> >
> >
> >
> >
> >
> > -Original Message-
> > From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> > Jitendra Kalyankar
> > Sent: Thursday, October 20, 2005 4:14 PM
> > To: ActiveDir@mail.activedir.org
> > Subject: [ActiveDir] Need ADSI Scripting help.
> >
> &
Re: [ActiveDir] Need ADSI Scripting help.
Wow! Thanks Joe for your reply & also thanks Mark too. I tried my best to explain to my manager but in vein so I am back to square one. If my own manager is not comfy with it what will I tell the Security! I know the scripts are as dangerous as your util or even more so but those who know how to go about it, not the one who will be using it. Yeah it would be even better if your oldcmp would guage intelligence ;-), can you do that? :-D Anyways I will continue using your utilities free or not. Care to shed more light on the question I asked? And I guess its more of want to know how you did it than what my company requires. Anyways I will find it out sooner or later. But anyways thanks very much guys for your help. Sincerely, Jitendra Kalyankar On 10/20/05, joe <[EMAIL PROTECTED]> wrote: > Just as an FYI, scripts are just as dangerous or more so. It is why I wrote > oldcmp in the first place. Too many people biting themselves in the ass. I > don't know how I could put more rubber bumpers on that tool unless I started > asking questions to gauge levels of intelligence and whether or not certain > switches should be allowed. :o) > > I understand the security department route though too. If they are antsy > because it is freeware, let me know and I can charge you 100k or so for it > and you get everything you get now plus a bill. :o) > > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jitendra Kalyankar > Sent: Thursday, October 20, 2005 4:29 PM > To: ActiveDir@mail.activedir.org > Subject: Re: [ActiveDir] Need ADSI Scripting help. > > I know about the Oldcmp.exe, but the thing is the tool is really powerful > and I don't want Jr. Sys. Admins doing something or deleting something that > they are not suppose to. And again I will have to go through the security > department route to use it. Too much hassel > > Hope that explains my situation. > > Sincerely, > Jitendra Kalyankar > > On 10/20/05, Creamer, Mark <[EMAIL PROTECTED]> wrote: > > Before you do this, see oldcmp at www.joeware.net > > > > http://www.joeware.net/win/free/index.htm > > > > > > > > > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Jitendra > > Kalyankar > > Sent: Thursday, October 20, 2005 4:14 PM > > To: ActiveDir@mail.activedir.org > > Subject: [ActiveDir] Need ADSI Scripting help. > > > > I am looking for some example script and/or help for the script I am > > writing for my company. What I want to achieve is if I run the script > > against the machine list which will be in the text file, it should > > give me the output in the text file saying which machine account is > > enabled, disabled or not found. > > > > I know how to manipulate the text files using fso object but I am not > > sure what do I need to use to get the attributes of computer container > > in AD. Any help in this regard is highly appreciated and valued. > > > > Please let me know if you need more information abou this. > > > > -- > > Thanks, > > Jitendra Kalyankar > > List info : http://www.activedir.org/List.aspx > > List FAQ: http://www.activedir.org/ListFAQ.aspx > > List archive: > > http://www.mail-archive.com/activedir%40mail.activedir.org/ > > > > This e-mail transmission contains information that is intended to be > confidential and privileged. If you receive this e-mail and you are not a > named addressee you are hereby notified that you are not authorized to read, > print, retain, copy or disseminate this communication without the consent of > the sender and that doing so is prohibited and may be unlawful. Please > reply to the message immediately by informing the sender that the message > was misdirected. After replying, please delete and otherwise erase it and > any attachments from your computer system. Your assistance in correcting > this error is appreciated. > > List info : http://www.activedir.org/List.aspx > > List FAQ: http://www.activedir.org/ListFAQ.aspx > > List archive: > > http://www.mail-archive.com/activedir%40mail.activedir.org/ > > > > > -- > Thanks, > Jitendra Kalyankar > List info : http://www.activedir.org/List.aspx > List FAQ: http://www.activedir.org/ListFAQ.aspx > List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ > > List info : http://www.activedir.org/List.aspx > List FAQ: http://www.activedir.org/ListFAQ.aspx > List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ > -- Thanks, Jitendra Kalyankar List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
Re: [ActiveDir] Need ADSI Scripting help.
I know about the Oldcmp.exe, but the thing is the tool is really powerful and I don't want Jr. Sys. Admins doing something or deleting something that they are not suppose to. And again I will have to go through the security department route to use it. Too much hassel Hope that explains my situation. Sincerely, Jitendra Kalyankar On 10/20/05, Creamer, Mark <[EMAIL PROTECTED]> wrote: > Before you do this, see oldcmp at www.joeware.net > > http://www.joeware.net/win/free/index.htm > > > > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of > Jitendra Kalyankar > Sent: Thursday, October 20, 2005 4:14 PM > To: ActiveDir@mail.activedir.org > Subject: [ActiveDir] Need ADSI Scripting help. > > I am looking for some example script and/or help for the script I am writing > for > my company. What I want to achieve is if I run the script against the machine > list which will be in the text file, it should give me the output in > the text file > saying which machine account is enabled, disabled or not found. > > I know how to manipulate the text files using fso object but I am not sure > what do I need to use to get the attributes of computer container in AD. Any > help in this regard is highly appreciated and valued. > > Please let me know if you need more information abou this. > > -- > Thanks, > Jitendra Kalyankar > List info : http://www.activedir.org/List.aspx > List FAQ: http://www.activedir.org/ListFAQ.aspx > List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ > > This e-mail transmission contains information that is intended to be > confidential and privileged. If you receive this e-mail and you are not a > named addressee you are hereby notified that you are not authorized to read, > print, retain, copy or disseminate this communication without the consent of > the sender and that doing so is prohibited and may be unlawful. Please reply > to the message immediately by informing the sender that the message was > misdirected. After replying, please delete and otherwise erase it and any > attachments from your computer system. Your assistance in correcting this > error is appreciated. > List info : http://www.activedir.org/List.aspx > List FAQ: http://www.activedir.org/ListFAQ.aspx > List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ > -- Thanks, Jitendra Kalyankar List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
[ActiveDir] Need ADSI Scripting help.
I am looking for some example script and/or help for the script I am writing for my company. What I want to achieve is if I run the script against the machine list which will be in the text file, it should give me the output in the text file saying which machine account is enabled, disabled or not found. I know how to manipulate the text files using fso object but I am not sure what do I need to use to get the attributes of computer container in AD. Any help in this regard is highly appreciated and valued. Please let me know if you need more information abou this. -- Thanks, Jitendra Kalyankar List info : http://www.activedir.org/List.aspx List FAQ: http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/
