Tuesday, January 25, 2022

External Hard Drive

External Hard Drive

How can I connect my external hard drive to the Hyper-V virtual machine?

Reply:

HI,

Its simple you can connect Directly any External HDD or USB drive to Hyper-v machine

Please use below link.

http://www.howtogeek.com/223193/how-to-access-local-and-usb-hard-drives-in-your-hyper-v-virtual-machine/

Thanks

Mahipal Singh

Noida


------------------------------------
Reply:

Hi

If it is required in an environment where USB drives are allow to be used with servers this will help you of getting access to external storage from within a vm. It's a very useful way of seeding initial copies of backup data.

1. Attach the USB drive to the Hyper-V host server.

2. Right click the USB disk (in our case Disk 1) and select Offline.

3. Disk 1 is now offline.

4. Select the vm Settings of the vm that you want to Add the USB drive to and select the SCSI Controller, highlight Hard Drive and click Add.

5. Select Physical hard disk, using the pull down menu you should see the offiline disk on the host available to you, select it and click Apply, click OK.

6. Within the vm start Server Manager, select the Tools menu, and select Computer Management, expand Disk Management, and you should the USB disk is offline. Right click Disk 2, and select Online.

7. You can now see the disk in File Explorer on the VM and can copy data to and from it.

To dismount the disk perform the following steps.

1. In the VM go to Disk Management, and select Disk 2 (in this example) and set to Offline.

2. In the Settings of the VM, expand SCSI Controller, and select the Hard Drive that you have used to mount the USB disk. Click Remove, Apply, OK.

3. Right Click the USB icon in the System Tray and select Eject.

Hope this will help you to perform external disk with Hyper-V.

Kindly click "Mark as Answer" on the post that helps you, this can be beneficial to other community members reading this thread.

Regards.

H.shakir


------------------------------------
Reply:

FYI - not all USB disks can be simply attached as a Passthrough disk

the driver for the USB disk must expose the disk as a 'disk drive' to the operating system and not a 'removable disk'.

That is the key.

If you USB disk is USB 3 and you have a USB 3 hub on your PC, you can use Direct Device Assignment to attach the USB HUB to the VM, then the disk will be like any removable disk.


Brian Ehlert
http://ITProctology.blogspot.com
Learn. Apply. Repeat.


------------------------------------

REGISTRY : "Audit: Shut down system immediately if unable to log security audits"

Hello,

Do you know where I can find, in the registry, the matching value "Audit: Shut down system immediately if unable to log security audits" ?

Regards,

  • Changed type Bill_Stewart Monday, March 6, 2017 7:02 PM
  • Moved by Bill_Stewart Monday, March 6, 2017 7:02 PM Off-topic help vampire post

Reply:

That part of the security log is hidden and protected.  It cannot be changed by normal means.  It is normally set or changed through Group Policy.


\_(ツ)_/


------------------------------------
Reply:

Yes, of course.

I don't want to make any change.

It's not the goal of the issue.

The goal is only to read the values through a script (batch, powershell, vbs), inside the registry or other place, not more ...

...and the values can be done by the Windows Domain GPO and also by the Local GPO (manually on each server).

Regards,


  • Edited by Cerkyr Thursday, January 26, 2017 4:26 PM

------------------------------------
Reply:
What's provoking the question?

-- Bill Stewart [Bill_Stewart]


------------------------------------
Reply:

The final goal is to confirm the good configuration (that come from Domain GPO and Manual Local GPO) of our servers through scripts and (maybe) put the values Inside inventory tool.


------------------------------------
Reply:

Do you have evidence that the GPO setting is not being applied?

All you have to do is run gpresult and see that it is being set.


-- Bill Stewart [Bill_Stewart]


------------------------------------
Reply:

The final goal is to confirm the good configuration (that come from Domain GPO and Manual Local GPO) of our servers through scripts and (maybe) put the values Inside inventory tool.

You should be posting this question in the Group Policy forum.

"RSOP Logging Mode" can validate this and it is where you need to start.  As your domain admins for help on this.


\_(ツ)_/


------------------------------------
Reply:

Considering that a human is doing changes inside Active Directory and/or directly inside the Local Group Policies, and then "error is human", we must control the activites done through a other tool.

But we don't want to do the controls manually, we want to collect the Domain and Local GPO configurations applied on our servers, through script(s); and then the controls can take less times.



  • Edited by Cerkyr Friday, January 27, 2017 9:18 AM

------------------------------------
Reply:

"RSOP Logging Mode"

I try to understand what is your proposal ...

Can you explain ?


------------------------------------
Reply:

"RSOP Logging Mode"

I try to understand what is your proposal ...

Can you explain ?

Ask your AD Admins to help you with this. 

Post in GP forum for help with Group Policy or, as Bill suggested, use gpresult.

These are all basic administration tools that any administrator or desktop tech will be able to help you with.  Start by typing GPRESULT /?


\_(ツ)_/


------------------------------------

Insiders with RELEASE PREVIEW ring : you have a new Cumulative Update.

Cumulative Update KB3216755 for Release Preview Ring.

That will push your build to 14393.726

Direct download links :

  • Changed type ZigZag3143x Friday, January 27, 2017 2:43 PM Not a question

problem displaying colors in RDP

Hi, please advice, i do not know. We have an application that has a red background. When you release this application on a local desktop color is see. picture 1. when the user logs over RDP color See Picture 2.. Please set as RDP environments that colors are the same as a local desktop?

Thanks,

PSv.


Reply:

How do you have color defined on the display tab of your connection?


. : | : . : | : . tim


------------------------------------

Mounting RWM Files

I have seen similar questions to this but I haven't found an answer anywhere.  Can someone tell me how to mount an image that consists of an RWM file and one or more WIM files?  Mounting the WIM file with DISM returns the error "1812 the specified image file did not contain a resource section".

Also, how can you find the contents of an RWM file?

Thanks

Bert


Reply:

A Res.rwm file that contains all the file resources for all images in the image group. The data within Res.rwm is single-instanced and compressed.  I suggest you read the "What happened to the Singl Instance Store" part in this: http://technet.microsoft.com/en-us/library/cc732729(WS.10).aspx 

In addition, I suggest you ask this question in Windows Server forum: http://social.technet.microsoft.com/Forums/en-US/winserversetup/threads

Thanks for your understanding and cooperation!

Regards,

Miya

TechNet Subscriber Support

If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.



Miya Yao

TechNet Community Support


------------------------------------
Reply:

Thanks for the reply, Miya, but that doesn't answer my question.  I know what the file is and what it is used for, etc.  What I don't know is how to mount it so I can service it.

Bert


------------------------------------
Reply:

I suggest you ask this question in Windows Server forum: http://social.technet.microsoft.com/Forums/en-US/winserversetup/threads

It's more professional on WDS questions.

Thanks for understanding and cooperation!

Regards,

Miya


Miya Yao

TechNet Community Support


------------------------------------
Reply:

In WDS go to your image group, right click the Image and disable it. Right click again, and chose export image. You can now mount and modify the image you just exported.

After you are done, right click the image in WDS again and chose "replace image". That's all, not nice... but hey... :)


------------------------------------
Reply:

Thanks Sebastian,

i am studying for the 70-411 and i came across this error in my lab so easy to follow your instructions and it works.

i know it has been a while since you postted this but  Thanks

Ken


------------------------------------
Reply:

Thanks for the helpful reply.

To the TechNet Forum Assistant, your replies were completely unhelpful and I am very grateful at the time saved by having the answer anywhere, even here. This forum includes deployment, and this was a valid deployment question.


MCSE 2003


------------------------------------
Reply:
Thank you very much for the helpful reply Sebastian!
Seriously, you would think MS employees make it difficult on purpose :).

------------------------------------
Reply:
All these years later, still a valuable suggestion!!  +1

Technology Administrator Erie County (Career and) Technical School.


------------------------------------

1-26-2017 downloded windown 10 upgrade

upgraded this morning, widows has shut down my wyfy,  my at&t service is still working,  the computer I am working on has not had the  new Microsoft upgrade!

DO NOT INSTALL THIS UPGRADE !!!!

  • Moved by Sheng Jiang 蒋晟 Saturday, January 28, 2017 3:52 PM not dev related, use answers.microsoft.com instead

New blog post, just FYI, to download the new NPS Technical Reference for WS16

Just FYI, new blog post "Download the New Network Policy Server (NPS) Technical Reference for Windows Server 2016" at https://aka.ms/nps2016

Thanks -


James McIllece

Just FYI, new blog post "Download the New Network Policy Server (NPS) Technical Reference for Windows Server 2016"

Just FYI, new blog post "Download the New Network Policy Server (NPS) Technical Reference for Windows Server 2016" at https://aka.ms/nps2016

Thanks -


James McIllece

Database Engine Tuning Advisor crash with plan cache option

I am using Database Engine Tuning Advisor with SQL Server 2012 SP3. This is a node that join part of a cluster but else, is a secundary node of replication with logshipping, where have a instance with production database (cluster) and others databases in restore state (Logshipping sql server 2005)     When I select any database user (production) and run, in less a minutes it crashes with the message "Tuning process exited unexpectedly. (DTAEngine)".  And I not found any file of error in the path C:\Program Files (x86)\Microsoft SQL Server\110\Shared\ErrorDumps     My account is in the sysadmin role.    Sql Server version is Microsoft SQL Server 2012 (SP3) (KB3072779) - 11.0.6020.0 (X64)

Absolute Beginner: Writing a windows script to automate tasks in an Oracle Application

Hi all,

I'm an absolute amateur at scripting, coding, program, etc. At work I have an extremely manual process that is very time consuming and takes up hours of my morning (every morning) to complete. We use an oracle application to order/purchase items we need. No one in the company wants to improve the process and are good with the status quo, but I'd like to be more efficient in this.

Currently, I'm manually typing in all the order criteria into this application. Is there a way for me to automate this process using scripts?

Obviously examples would be helpful, but I wanted to see if this is even feasible. Any and all help would be wonderful. Thank you

  • Changed type Bill_Stewart Monday, March 6, 2017 6:58 PM
  • Moved by Bill_Stewart Monday, March 6, 2017 7:00 PM Outside forum scope by many orders of magnitude

Reply:

This is a bit like asking "I would like to drive my car somewhere but I don't know how. My car is a Volkswagen. Can you help?"


-- Bill Stewart [Bill_Stewart]


------------------------------------
Reply:

This is a bit like asking "I would like to drive my car somewhere but I don't know how. My car is a Volkswagen. Can you help?"


-- Bill Stewart [Bill_Stewart]

I would have to disagree. It's more like, "Hi I'd like to fly my helicopter somewhere but I don't know how. My helicopter is an Apache AH Mk1 Helicopter, can you help?"

I literally don't know anything about scripting or where to start. That's why I came to this forum, hoping that someone could give me some basics and/or maybe ask some questions to help a beginner or point me in the right direction. For instance, "What kind of application is it?" "Oh that application doesn't allow for windows scripting, you'll need to download xyz program" etc


------------------------------------
Reply:

Right, so you can see, then, that your question is pretty much unanswerable. (For example: Are you asking for specifics about how your helicopter works? Are you asking for directions to somewhere? Or are you asking about something else? We have no idea because you don't say.)

Peruse the other questions in this forum for examples (both good and bad) of how to ask questions in a technical forum.


-- Bill Stewart [Bill_Stewart]


------------------------------------
Reply:
Please read through the following for some more information on how you can ask.

-- Bill Stewart [Bill_Stewart]




------------------------------------
Reply:

Yes I've read through those now, thank you for providing. I still need help in describing what kind of oracle application I'm using. I don't know what to Google or search in the forums as this seems to be a custom application for my company. How do I find out if this Oracle application will allow any kind of "button pushing" or automation from my windows OS? 

Does any of that help? I literally have no knowledge of scripting and came here for someone to hopefully help me articulate my problem and find a resolution or at least understand this further so I can research on my own. I just need some help and direction.


------------------------------------
Reply:

You are asking for a lot and there is really no way to do this other than to start by gaining an education in computer technology and programming.

You could also just look at your browser and see the item on top of this page that says "Learn".

The best way to learn technology is to keep your eyes open and look for things you can understand and use like reading the menu items on a site.


\_(ツ)_/


------------------------------------
Reply:
I just need some help and direction.

I believe that's been provided. It is simply impossible to answer this kind of vague question from afar in a forum. We cannot read your mind, we know nothing about your company's application, and we can't see your screen.


-- Bill Stewart [Bill_Stewart]


------------------------------------
Reply:

Yes I've read through those now, thank you for providing. I still need help in describing what kind of oracle application I'm using. I don't know what to Google or search in the forums as this seems to be a custom application for my company. How do I find out if this Oracle application will allow any kind of "button pushing" or automation from my windows OS? 

Does any of that help? I literally have no knowledge of scripting and came here for someone to hopefully help me articulate my problem and find a resolution or at least understand this further so I can research on my own. I just need some help and direction.

You would start by posting in a Oracle forum for your product.  That is the absolute second thing to do.  The first is to read the documentation for the product and look up additional documentation on the Oracle site.

There is nothing we can do to help you  with this.  It is what all scripters have to do.


\_(ツ)_/


------------------------------------
Reply:

Yes I've read through those now, thank you for providing. I still need help in describing what kind of oracle application I'm using. I don't know what to Google or search in the forums as this seems to be a custom application for my company. How do I find out if this Oracle application will allow any kind of "button pushing" or automation from my windows OS? 

Does any of that help? I literally have no knowledge of scripting and came here for someone to hopefully help me articulate my problem and find a resolution or at least understand this further so I can research on my own. I just need some help and direction.

You would start by posting in a Oracle forum for your product.  That is the absolute second thing to do.  The first is to read the documentation for the product and look up additional documentation on the Oracle site.

There is nothing we can do to help you  with this.  It is what all scripters have to do.


\_(ツ)_/

Thank you for pointing me in a general direction JRV. That's a very helpful first step, I'll head over there.

------------------------------------
Reply:
All new adventures should start with enthusiasm and baby steps.

\_(ツ)_/


------------------------------------

What do you think about this new Userform control for Excel - Virtual Forms

Hello guys,

this project is still in Beta and in development, and is (for now) for 32-bit Office only.

It's called Virtual Forms.

It's an ActiveX control that helps to quickly build Master-Detail forms for data manipulation (CRUD).

The webpage is: virtual-forms.com

I would be very grateful for your comments here or maybe on the community portal on support.virtual-forms.com

Thank you,

Davor




DFS NAMESPACE NAO INICIA

Prezados amigos de infraestrutura es com um problema que o servicos de DFS na inicia nem com reza forte, preciso de ajudar.

Desde ja agradeço 

 

BITLOCKER RECOVERY KEY

  My Surface Pro 3 shut down after my battery ran down flat a week ago. On trying to turn my system on, the Surface Pro 3 requested for my Bitlocker Recovery key. I was able to get the Bitlocker Recovery Key using another device and I used it and my Surface Pro3 came on again. My only problem now is that whenever I shut down the system, it refuses to turn on, except I re-enter the 40-digit Recovery number before I have access to my files and documents. I find that as a serious inconvenience to me. Kindly advise me on how the system will operate normally so that I don't have to re-enter a long string of 40-digit number before I have access to my Surface Pro 3 please.

Best regards

Kilyobas Binga


  • Edited by Killybinga Monday, January 23, 2017 8:28 PM

Reply:

Please go to bios settings and see if the TPM is still turned on. If not, turn it on.

Enter the recovery key, then and reboot and see if it vanishes.


------------------------------------

IPs to open on TMG proxy in order to open the authentication for Skype for business & Office 365

Dear Team, 

I already have all the IPs to be added but i dont have any idea in TMG to add these IPs, any body can help how to allow the IPs to open on TMG proxy in order to open the authentication for Skype for business & Office 365.

Do I have to create a rule or is there a way to add these IPs its more than 200 

About Formatting my sd card

Hellow Dear,
I can't format my micro sd card...it's log Name is : Microsoft-Windows-Kernel-PnP/Device Configuration... would u pls help me to recovering my sd card? 


Reply:

Hi

This is an exchange forum, please post in the correct windows forum.



------------------------------------

SQL Server vs. Teradata

My company is cCurrently a SQL Server shop but I was just informed that I'm to meet with some reps from Teradata to listen to the Teradata sales pitch then ask questions.  The DB is fairly big (about 4 billion rows and about 600GB).  It uses SSRS to run reports agains the data set.

My knowledge of Teradata is that it is horribly expensive and tends to be inflexible.

I've found some links pertaining to SQL Server (2008 or 2005) vs. Teradata but thought I'd post here as well to see if anyone has any suggestions of things I can ask the Teradata reps to find where Teradata struggles compared to SQL Server.

The company's idea is to have a standard tool (possibly Teradata, possibly SQL) to run similar apps/db's accross the company.  MY view is we need complete flexibility.  SQL can offer that, but Terdata will struggle but again, my knowledge of Teradata is quite limited.

Any help will be appreciated.

Thanks


Reply:
Coming from a Teradata shop, I'm not sure what you mean by "inflexible."  Teradata by design is a distributed architecture, which works well for querying extremely large data sets in a very fast manner.  In order for that to work though, careful design and implementation need to be done.

For instance, data distribution is key to making Teradata work well.  If you are joining two tables on a column that isn't very unique in one table (say there is a single value in the join column on table 2 that comprises 75% of all the rows in table 2, and a mix of other values for the remaining 25%), the query will skew and will not perform very well.  At times this is unavoidable, of course, but again, design is key. 

Teradata is better served when you know (or can tightly control) the types of queries being executed against it.  It is not well suited for many ad-hoc queries that vary greatly...

But, we don't really know your environment, and as such cannot really comment if it is a good fit or not.  Don't worry about cost - if Teradata wants your business they will work with you.  So have the meeting and listen to what they have to offer.  By all means, be up-front with them on what your needs are today and in the future.


Phil Brammer | http://www.ssistalk.com | Twitter: http://twitter.com/PhilBrammer

------------------------------------
Reply:
Thanks for your insight. 

I should have been more specific about our environment.  It is very-dynamic, ad-hoc, and fluid. 
It is constantly changing based on new requirements.  Due to the nature of the data/application/customer environment, it is impossible to gather all requirements up front. 

There are a lot of "canned reports" that users can just execute, but there is also a lot of ad-hoc or one-off data pulls to support certain anaylisys. 
In addition, we frequently recieve additional data metrics from our customer (they continually add additional points of data capture). 
This customer has a lot of data and most of it isn't being utilized.  So data captured down the road will include what we have today but will also include an undeterminable set of data in the future.

Based on projects requested by the customer, we may require additional data metrics that we do not currently receive, but that our customer captures. 
So we must be able to quickly add additional data.  That might be a single column, an entirely new table or a completelly new set of tables that relate to one or more existing tables.
In some instances there might be a complete database that needs to be joined in.  So flexibility is paramount to the success of this application.

So there are a set of reports/queries that are known, but a huge potential for unknown queries/future reports/user-driven ad-hoc pulls ...

As you said, the distribution architecture is automatic with a potential for poor performance specifically for random/ad-hoc/unknown types of queries that can not necessarily be controlled, nor would we want to control (read as limit) the query capabilities as the ad-hoc nature is the main requirement from the customer.

If my elaboration clears things up I'd realy like to hear more of your point of view/expertise.

Thanks again. 

------------------------------------
Reply:
As Phil indicated, Terradata is the right solution for some situations. You will need to very carefully document your use cases in order to sort out whether or not this is a Terradata situation.

One thing that I note is that you seem to have a heavy reliance on resporting. Have you explored the Scalable Shared Database technology introduced with SQL 2005?
"You cannot do a kindness too soon because you never know how soon it will be too late." -Ralph Waldo Emerson

------------------------------------
Reply:
There is a big difference between a limited set of "power" users running ad-hoc queries and an entire user-base running ad-hoc queries.  If the latter, then I suspect you'll run into performance "problems" on Teradata simply because there is no clear choice on database design with respect to indexes, data distribution, etc...

If you spend enough money on the architecture, it won't be an issue depending on how much volume and how many queries are being executed at once. 

Teradata is good for loading data as well - it has super fast loads (hey, it's called FastLoad even!).  As with any package, if properly done you will love it as will your users.

If you are looking for a quick answer from me such as "stay away from Teradata" or even "migrate as soon as you can to Teradata because it rocks" you won't get that from me.  The proverbial, "it depends" is at play here.


Phil Brammer | http://www.ssistalk.com | Twitter: http://twitter.com/PhilBrammer

------------------------------------
Reply:
Understood.  I'm not really looking for a yah or nah from this post.  As with everything, "It depends" or "It would have to be tested".
I looking more for what questions I should ask Teradata in order to determine a yah or nah.

I'm really just trying to determine if this is a feasible solution that offers complete flexibility from a technical/developer/DBA viewpoint rather than upper management having received a sales pitch from a good salesperson being convinced it's "Perfect!"

The entire user base will have the ability to do ad-hoc queries.  Of course, some will do more than others, some may not do any.

The data load for this app is 2 pronged.

Part of the app has traditional weekly appends.  This import currently takes about 60 minutes once a week. 
The data is received in the evening and is available by morning.  So speeding up the loads for that part isn't an issue.

The other part of the app is non-traditional in it's data load mechanism.  The data is a random sample of data.  Due to the random sample and the overall nature of the data and how the customer obtains the data, it is unable to do a traditional append of a set of data.  Appending data updates will invalidate the data.  Therefore this part of the app requires the old data to be dropped and the new data to completely replace the old.  This data is obtained typically every 2 months and takes about 24 hours to load and is typically loaded over a weekend.  Speeding that up would be helpful, but again, not critical.  Having the update available on Friday vs. the following Monday won't make a big difference to the users.

"If you spend enough money on architechture, it won't be an issue"  True, but that's true with just about anything.

I have not looked at Scalable Shared Database technology, but will definitely look into it. 
Scalability is a concern for my company's management due to the nature of this application.

Thanks

------------------------------------
Reply:
As everyone saying, it is all depends. I have been to companies with 1 to 2 TB worth of data and they doing great even with bad design. I have been to companies with only 100 GB in size, but struggling to keep up with database servers. I would do plus and minus list or ask an SQL Server Expert to visit and asses what I have and what I should I have. I will ask someone to look in to the database design and see if we can improve. Adding CPU, Memory and Hard disk is not going to make sql server perform well. This is the case for any database servers. Every product has its strength and weakness.

Before I move to something else, I would see why I am quitting the current one. If you know what you need, then it is easy to get it.

We do not know what we do not know. As soon as you know, you may fix the current or buy new one.

Hope it helps.

------------------------------------
Reply:

Although this post is 7 years old, I must add what I think is an important issue:

The GUI of the tool that will be used by engineers/analysts to use the DB.

As of Teradata v16 vs MS SQL Management Studio, the difference is quite huge.

Teradata Studio 16 lacks a lot of user-friendly issues, that MS has.

At the end of the day, productivity of your DB depends a lot in  the time taken for your E/A to bild queries, program Store Procedures, etc... Specially in an environment that data consumption varies day to day (Like business analysts) 


------------------------------------

Before submitting a "Counterfeit Software Report" to MS, read their FAQ carefully

MS can decline your "Counterfeit Software Report" submission for a large number of reasons, including that you paid an unspecified price that is "significantly lower than the standard pricing for the software."

If they decline your submission, they still keep the software you submitted without compensating you, so you can't return it to the seller for a refund, per https://www.microsoft.com/en-us/howtotell/cfr/FAQ.aspx

I certainly won't be submitting bootleg software to MS again.

Here's the "declined" email they sent:

Thank you for submitting a counterfeit software report. We appreciate your efforts to help Microsoft in its fight against software counterfeiting. Unfortunately, after careful review, we have determined that the documentation you provided does not meet the criteria for the complimentary replacement software offer. Here are some of the reasons why we may have denied your request:

No original proof of purchase was included in your submission.
The receipt or invoice for the computer you purchased does not specify that it includes a copy of Office.
A CD/DVD was not included in the submission.
Wrong version of the software was received.
A product key was not included.
The purchase price for the counterfeit software was significantly lower than the standard pricing for the software.
Your Counterfeit Report Number: XXXX-XXXX

We realize that sometimes it can be challenging to tell whether software is genuine, and invite you to visit Microsoft's How to Tell website for more information. There you will find more information about genuine Microsoft software and how to determine if your copy of Office is genuine. You can also purchase a genuine copy of Microsoft Office.

Thank you for taking the time to report counterfeit software; the information you sent will be treated by Microsoft as confidential. We review every submission we receive; however, due to the sensitive legal nature of these matters, it is not possible for us to provide feedback or updates about actions taken on your report.

Microsoft respects your privacy. To learn more, please read our Privacy Statement.

Please visit FAQ page if you have additional questions.

Microsoft Corporation
One Microsoft Way
Redmond, WA, USA 98052

Reconfigure subnets to meet new schema model

I am new to PowerShell and am interning at a place where we have a print server with about 20 subnets. They are implementing a new schema format where each printer needs to be in ports ending in the range of 50-60. I am trying to create a script that will get all the current ports in use and separate them by the 3rd subnet value then iterate through those subsets and determine if the last value is within range. If not, it needs to get the next value available and reassign the printer to that port. Example: Existing is 192.168.100.50, 192.168.100.54, 192.168.100.120; first 2 are within range and the last would need to be reassigned to 51 or 55, whichever is easiest.

All these changes need to be tracked so each computer within each subnet can make the same changes so the network printers all line up with the changes that are made on the local machines. There are about 200 computers total within the 20 subsets.

I have found many different methods to get all the ports in use and using the -split '\.' to get them to breakout into the individual subnets, but I cannot access the final set to determine if they are in range or not. I recently tried making an embedded foreach loop that gets the individual port, then goes through each of them to break each segment into System.Object arrays, but it always give the full IP value no matter what I do.

I can post the several different scripts I've tried to use, but there are several. Any pointers or references you can offer are greatly appreciated.


  • Changed type Bill_Stewart Monday, March 6, 2017 6:53 PM
  • Moved by Bill_Stewart Monday, March 6, 2017 6:54 PM Nonsensical/user doesn't understand technology or scope of question

Reply:
What's your specific question? Are you asking how to determine if an IP address is within a specific range of IPs?

-- Bill Stewart [Bill_Stewart]


------------------------------------
Reply:

There is no relationship between ports and subnets.  YOU statement is very vague and confusing.

As Bill has noted, you need to ask a specific and clear question.

There is no way to get all "ports in use". There can be thousands of ports in use at any time. A program that is using a port may not be running and there is no way to know that it is using a port.

I recommend that you contact a good consultant to work with you to help define what it is you need.  You will need to find a consultant certified in internetworking and in Windows networking.


\_(ツ)_/


------------------------------------
Reply:

What the OP is saying is that they are trying to insure that the 4th octet of the IP address assigned to the printer ports on the print server is in the range of 50 to 60.

He is not able to determine the value of the 4th octet.


------------------------------------
Reply:

$ip='10.0.0.33'
($ip -split '\.')[3]


\_(ツ)_/


------------------------------------
Reply:

A meaningful 4th octet depends on the network mask.


-- Bill Stewart [Bill_Stewart]


------------------------------------
Reply:

I was having some trouble trying to state my problem in a clear and concise manner. The ultimate goal is to apply GPO that will limit printer accessibility based on the subnet address. I see where you would be confused on that. Each of the printers on the server have port addresses that align with branch locations and their designated subnet address.

For Example:

Branch Location          Subnet          # Printers

Seattle                     192.168.1.1    6

Kent                         192.168.2.1   3

Etc...

Currently all branches can access all printers and it creates confusion within the company. So we will create a GPO that says you can only access printers based on your machine's IP. There are certain situations where cross-branch printing needs to occur, which can also be handled through the GPO. We also want to be able to quickly recognize device type based on 4th octet ranging. All printers will be set to end in the 50-60 port range.

Where I keep running into problems is I believe I am successfully [-split '\.' or .Split(".")] but something happens when I get to the last octet. I have several different scripts I've started, abandoned, but saved and they all pretty much end up the same.

I have been using the Get-WMIObject -Class WIN32_TCPIPPrinterport but it was also recently suggested for me to use CIM instead. Is there any great resources out there that can point me to splitting up the IPs, inserting an array for the 3rd set (all the IP subsets) and comparing 4th to a range?


  • Edited by sq213 Friday, January 6, 2017 8:13 PM

------------------------------------
Reply:

It is still not clear what you are asking. What do you mean by "50-60 port range"? Do you mean the last octet of the IP address will be in the range 50-60? (An octet of an IP address is not ever called a "port".)

Network IDs (often referred to as "subnets") in IPv4 addressing depend on the network mask (often referred to as "subnet mask") being used.

Are you saying that all network IDs in your organization use 24 bits? (i.e., 255.255.255.0) Because if not, then I don't think that "4th octet" (if that is what you mean by "port") means what you think it means.

If you don't understand what I'm saying, then I'd recommend taking a networking class where they can explain how IP addressing works, and things will start to make more sense.


-- Bill Stewart [Bill_Stewart]


------------------------------------
Reply:
Yes, I mean 4th octet when I'm referring to port range 50-60. We are using the default 255.255.255.0 (subnet) mask. I know I'm using the term port loosely, and networking is not my primary thing. I do forget at times port is not the correct terminology. Really what I should be saying is the last set of the IP address needs to be in the range of 50-60. Again, truly sorry for misusing terminology; it does make all the difference in the world :)

------------------------------------
Reply:

Now that we've clarified the terminology, please ask your question again.

Make sure that you ask a specific and targeted question.

For example, "How do I determine the last octet of an IP address in PowerShell?"


-- Bill Stewart [Bill_Stewart]


------------------------------------
Reply:
Yes, I mean 4th octet when I'm referring to port range 50-60. We are using the default 255.255.255.0 (subnet) mask. I know I'm using the term port loosely, and networking is not my primary thing. I do forget at times port is not the correct terminology. Really what I should be saying is the last set of the IP address needs to be in the range of 50-60. Again, truly sorry for misusing terminology; it does make all the difference in the world :)

You are saying many things but you have not sorted it in your head with or without correct terminology.  I will also say you are stuck in this due to lack of a network design.  It is a network that was grown out of the weeds.

There is no way - no matter what 4th octet values you have - to know which addresses are in use.  YOU either need a spreadsheet,   database or DHCP to handle this,

YOU are saying two unrelated and conflicting things in one breath. YOU want to allocate an address to a printer??? How can that be done via a GPO?  I see no way.  If you are really trying to say you need to assign a printer then that would be done by DNS address and not by IP.

If you have a simple subnet scheme like 255.255.255 then only the last 256 numbers would be in a subnet.  If you need to detect the subnet just XOR the mask with the IP or create a switch statement and match the first three octets.  What this ahs to do with printers is a mystery.

If the 3 octets match the attach a known printer that belongs to that subnet.

The best way to do this is to define sites and subnets in AD.  You can then easily retrieve the subnet for the current user in tow lines of code.  You can also add to the site definition and define the printers that belong to that subnet.  We would never use printer IP addresses when names are much more reliable.

You can also use GP to assign printers based on Group or OU membership.


\_(ツ)_/


------------------------------------
Reply:

I was having some trouble trying to state my problem in a clear and concise manner. The ultimate goal is to apply GPO that will limit printer accessibility based on the subnet address. I see where you would be confused on that. Each of the printers on the server have port addresses that align with branch locations and their designated subnet address.

For Example:

Branch Location          Subnet          # Printers

Seattle                     192.168.1.1    6

Kent                         192.168.2.1   3


A subnet in you topology would be 192.168.1.0/24, 192.168.2.0/24. 192.168.3.0/24

There are NO port addresses in IP subnets.


\_(ツ)_/


------------------------------------
Reply:

Currently all branches can access all printers and it creates confusion within the company. So we will create a GPO that says you can only access printers based on your machine's IP. There are certain situations where cross-branch printing needs to occur, which can also be handled through the GPO. We also want to be able to quickly recognize device type based on 4th octet ranging. All printers will be set to end in the 50-60 port range.

Where I keep running into problems is I believe I am successfully [-split '\.' or .Split(".")] but something happens when I get to the last octet. I have several different scripts I've started, abandoned, but saved and they all pretty much end up the same.

I have been using the Get-WMIObject -Class WIN32_TCPIPPrinterport but it was also recently suggested for me to use CIM instead. Is there any great resources out there that can point me to splitting up the IPs, inserting an array for the 3rd set (all the IP subsets) and comparing 4th to a range?


Get-TCPIPPrinterPort does not give you what you want. 

Access to printers is controlled by security.  Set the security on the printers to only allow correct groups.  If you are no using a print spooler then set one up and use it.  It will allow you to manage printers based on subnet and it does not require any scripting.


\_(ツ)_/


------------------------------------
Reply:
Yes, I mean 4th octet when I'm referring to port range 50-60. We are using the default 255.255.255.0 (subnet) mask. I know I'm using the term port loosely, and networking is not my primary thing. I do forget at times port is not the correct terminology. Really what I should be saying is the last set of the IP address needs to be in the range of 50-60. Again, truly sorry for misusing terminology; it does make all the difference in the world :)

What is "the last set of the IP addresses".  So far you have failed to state a clear issue. Try asking a simple question in the form of "How do I  ....?"

\_(ツ)_/


------------------------------------
Reply:

In my head, my question seems so clear haha.

How do I breakdown an IP address into 4 octets and search the IP based on 3rd and 4th octet value? Ultimately, this is what I need to be able to do. The rest was more information than necessary and just confused the situation.

I appreciate your patience and apologize for causing confusion. Like I said, I'm new to this and am an intern.


------------------------------------
Reply:

How do I breakdown an IP address into 4 octets and search the IP based on 3rd and 4th octet value? Ultimately, this is what I need to be able to do. The rest was more information than necessary and just confused the situation.

$ipaddress = '192.168.3.33'
$octets = $ipaddress -split '\.'
$octets[2]
$octets[3]


\_(ツ)_/


------------------------------------
Reply:
Thank you for your help. I realized what I was trying to do was not actually possible as it leads to a security risk. Allowing a script to change any IP address would potentially cause havoc from an invasive script attack that is designed to go and change IP addresses.

------------------------------------

Tascam US-122 with Windows 8

Hi everyone,

After some struggle with the Tascam's drivers for Windows 8 (8.1 to be accurate), here is the way to go:

1) Download TASCAM_USB2_X64_2.02 from http://tascam.com/product/us-122l/downloads/ and unzip it - do not launch the setup at this stage, because it will fail.

2) Plug-in the device

3) Go to you Device Manager in the Control Panel and look for TASCAM US-122L MIDI. Right click and choose "Update Driver Software. Browse your local files and select the TASCAM_USB2_X64_2.02 folder and OK. This should be successful and the device should now be found in the Sound,etc category. Now you're halfway though, you still need to deal with the unrecognized TASCAM US-122L.

4) Launch the installer Setup.exe (in the TASCAM_USB2_X64_2.02 folder) and proceed with the required steps. Now this should be successful (this is the step that was failing before unless you proceed with step 3 here).

5) Check that the sound card is now available as a playback device (right click on the sound icon in the bottom right)

6) Select the new "Speakers" as default

7) Listen

I hope you'll be as *lucky* as I was - because hardware firms often fails to keep up with OS releases...

Bests.



Reply:

1st:  This is a Windows 7 forum, not Windows 8.  The Windows 8 forums are @ http://social.technet.microsoft.com/Forums/windows/en-US/home?category=w8itpro

2nd:  Nothing in the list you refer to claims the software is compatible with Windows 8.  Therefore you must contact TASCAM Technical Support to determine if the software is compatible with Windows 8.  Microsoft cannot fix third party software - the publisher of the software must write it to be compatible with your system.


Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. "


------------------------------------
Reply:

Hi,

Thanks for your sharing.

Have a nice day!


Alex Zhao
TechNet Community Support


------------------------------------
Reply:

My TASCAM U224 I bought years ago has been working for me with all the updates for the last 10 years, until today, when the last update was installed.

Windows 7 32 bit.

The way I get successful install is by configuring the setup program of the tascam driver I loaded for Windows XP to work in compatibility mode with XP service pack 3. 

Got it to install, and even the test of stereo runs well, but no application is able to stream sound into it.

So unfortunate. Such a good card and working perfectly.

Only the last upgrade killed it. It worked great for years with Windows 7 professional.

Or


------------------------------------
Reply:

Hey this WORKS!

You saved me $100+ dollars for a new USB MIDI Interface......THANK YOU!


------------------------------------
Reply:

Just wanted to say thanks for this!

Simon


------------------------------------
Reply:
Sorry pal, but I have never read such rubbish as this in my life!

------------------------------------
Reply:

Even though that this may be a windows 7 forum and not windows 8 as previously stated by someone else I am very happy you put this up. As having a lot of problems with my Interface as I too have windows 8.1 and nowhere can I find a driver that will work and believe me I have looked everywhere.  It seems to work and then suddenly stops. I thought there was something wrong with my computer but new it couldn't be as I have a new Sony Vaio Laptop. I am trying it now so will let you know if I have succeeded.

Again Many Thanks for this post


------------------------------------
Reply:
Tascam states that the drivers for windows work with windows xp, windows 7 and windows 8 but for some reason driver keeps dropping off and when you try to contact Tascam you get no help and no reply, So I am glad this person put this up as I was running out of options.

------------------------------------
Reply:
Hi. Must thank you a lot ,as I was about to give up on this. I recently purchased a windows 8.1 to replace a Xp professional sp2 due to unable to load a melodyne software. But in doing this my tascam u122l would not load any drivers for my cuebase le. Tried different suggestions from other sites,but this method worked just as you said after restarting computer. Still early days but seems to be working fine. Thanks again.

------------------------------------
Reply:
No. The problem is with Windows Eight. This program is a hostile piece of crap designed to make you purchase other crappy programs. It is slow and heavy on processors and deeply flawed. 

------------------------------------
Reply:
I'm assuming the US-122 and US-122l are not the same product.  When I followed your instructions and plugged in my US-122 it did not show me a Tascam Midi in device manager....only unknown.  Update driver pointing to the unzipped folder just said driver not found.  :(  US-122 on Tascam site rather than US-122l does not have the zip files with individual drivers, only exe files.  Guess I'll try those next.  

------------------------------------

Visual Studio 2015 issue

Visual studio issue in creating new page

Reply:

You will need a Visual Studio forum. This one is for Visio.

Start here

https://www.visualstudio.com/


Paul Herber, Engineering and software shapes for Visio<br/> <a href="http://www.paulherber.co.uk/">Paul Herber</a>


------------------------------------

No comments:

Post a Comment

Setup is Split Across Multiple CDs

Setup is Split Across Multiple CDs Lately I've seen a bunch of people hitting installation errors that have to do with the fact th...