The system cannot find the file specified.
I get this error when I try to run a Script task in SSIS that references the RestSharp library. I made a reference to the dll.
ERROR:
Could not load file or assembly 'RestSharp, Version=105.1.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified. :
Reply:
Hi JazzManDell,
Can you check the below post.
Call REST API using SSIS Web Service Task / JSON / XML Source
------------------------------------
Support for SQL from Microsoft if the servers are in AWS
Hi,
I've found it quite difficult to get a definitive statement on this. What I do know is that Amazon do not support the SQL Server software itself only the platform and OS. Indeed they state "Issues with Microsoft applications running on an AWS instance should be submitted to Microsoft support." https://aws.amazon.com/windows/faq/. A colleague of mine called Microsoft and was told two different answers: 1. Call Amazon even if it's a SQL problem. 2. Install it in a MS environment or on a physical platform, then they will support you.
Interestingly, both equate to "no, Microsoft do not support SQL in AWS". But then I read posts that say that if I call MS with a SQL problem and mention that it's in AWS, they'll be fine with it.
So, is there a formal position from Microsoft on this?
TIA
m
EDIT: I have no idea how this ended up in "Database Design" as I thought I was posting in general. So, if a Mod would be so kind as to move it, that would be much appreciated.
- Edited by M.a.r.k.T. _ Tuesday, March 7, 2017 9:48 AM
- Changed type Lydia ZhangMicrosoft contingent staff Tuesday, March 28, 2017 2:18 AM
Reply:
Cheers,
Shashank
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from itMy TechNet Wiki Articles
MVP
------------------------------------
Reply:
Thank you. But when you say "it is supported", that's what Amazon say, only in the small print it says that they (Amazon) support the platform but for SQL support, call MS. So, when you say "Microsoft SQL Server is supported on AWs VM popularly called as IAAS architecture", do you mean that Microsoft (and that's the important bit) support it?
If so, are you able to point me at a referencable URL that backs this please? (Or a MS employee back this up.)
Thanks very much
------------------------------------
Reply:
Both answers could be correct, depending on what type of SQL you are running on AWS.
If you are using SQL with Amazon RDS, then you should contact Amazon for support first.
If you are running your SQL on an Amazon EC2 instance, your SQL support would come from Microsoft, while infrastructure support would come from Amazon.
See the below AWS documentation for more information about SQL on EC2 and RDS:
https://aws.amazon.com/windows/products/sql/
https://aws.amazon.com/rds/sqlserver/
------------------------------------
Reply:
Thank you but as per the OP, and one reply since, I already know that Amazon support the platform.
I'm also aware that people think that Microsoft support SQL itself. Sorry, but non-MS staff saying "they do" isn't going to cut it: I need MICROSOFT themselves to confirm. Anything else just has to be treated as fake news. ;)
@Teige Gao: a simple "yes, Microsft do support SQL in AWS" will suffice. :)
- Edited by M.a.r.k.T. _ Monday, March 13, 2017 9:22 AM
------------------------------------
Reply:
Hi,
Of course it's fine.
Microsoft doesn't care where your SQL runs as long as it is a supported SQL release (SQL 2008 and above) running on a supported operating system, and you are properly licensed.
They don't care if you're running SQL on Azure, IBM Softlayer cloud, Amazon AWS, VMware ESX infrastructure, HyperV, KVM or on a laptop at home as long as you meet the prerequisites above.
------------------------------------
Reply:
Untrue. They do care, for example for Exchange. (And I have it in writing.) So, I as posted above (a few times), I need Microsoft themselves to confirm it.
- Edited by M.a.r.k.T. _ Monday, March 13, 2017 9:56 AM
------------------------------------
Reply:
Hi M.a.r.k.T. _,
Did you install SQL Server on the VM of AWS? Which detailed error did you meet?
If this problem is related to the setting of AWS VM, you will need to ask for support from Amazon, if it is a problem related to SQL Server itself (such as database engine cannot start, SQL Server cannot upgrade), you can post a case here, we will support it.
Best Regards,
Teige
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
------------------------------------
Reply:
Cheers,
Shashank
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from itMy TechNet Wiki Articles
MVP
------------------------------------
Reply:
@Shashank: yes you are 100% right.
This is exactly what a colleague of mine said would happen (he tried the same thing): you ask this question and everyone except Microsoft opine: "of course they do", but you'll only get tumbleweed from Microsoft themselves.
Unfortunately, I'm in the situation where the opposite of a definite "yes" from Microsoft is a "no". :(
@Teige - you could save the day here. :)
------------------------------------
Reply:
------------------------------------
how to updae my credit card info on your format
lost my credit card.
have a new one. your format of editing this info will not allow me to do that.
Reply:
Hi wayne t reeves.
Could you please provide us with more detailed information about your problem (if it is someway related to Windows Vista)?
Bye.
Luigi Bruno MCP, MCTS, MOS, MTA
------------------------------------
Update error
I am trying to update and this is a message that I got. WindowsUpdate_80070490" "WindowsUpdate_dt000" .
Please help
SCCM 2007 Users
Requested deleted.
Luis Olías.
- Edited by Luis O.J Friday, March 17, 2017 9:12 AM
- Changed type Bill_Stewart Monday, March 27, 2017 6:48 PM
- Moved by Bill_Stewart Monday, March 27, 2017 6:48 PM Off-topic
Reply:
First, this is not an SCCM support forum. Second, this is not the right place for script requests. Read this first:
This forum is for scripting questions rather than script requests
-- Bill Stewart [Bill_Stewart]
------------------------------------
Reply:
------------------------------------
Reply:
Luis Olías.
------------------------------------
This idea will make people easily switch Windows 10
The main reason why people do not want windows 10 is that they got used to windows 7 theme.
My My proposal is to build a completely new feature that will be in the control panel. the feature is
"previous windows themes" .
If the user want windows 7 experience, he will go to this feature and chage the theme to windows 7.
This is an excellent reason why not destroy the old control panel.
- Edited by audio speech files in software for commercial use Friday, March 17, 2017 8:11 AM
- Changed type Carey FrischMVP Tuesday, March 21, 2017 2:47 PM Comment
- Moved by Carey FrischMVP Tuesday, March 21, 2017 2:48 PM Relocated
Holy Cow !........ Announcing Windows 10 Insider Preview Build 15060 for PC
excerpt ...................
Known issues for PC
- You will be unable to download new (additional) language packs on this build. Currently installed language packs will not be impacted.
- If your PC fails to install this build on reboot with the error 8024a112, reboot manually again. If your PC appears to hang during the reboot, power your PC off and back on and the install will proceed.
- Some Insiders have reported seeing this error "Some updates were cancelled. We'll keep trying in case new updates become available" in Windows Update. If you encounter it, please try deleting the following registry key: 1
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\Auto Update\RequestedAppCategories\8b24b027-1dee-babb-9a95-3517dfb9c552
Reply:
This time, those having UUP disabled will NOT get the update.
i had to enabled it.
Now downloading.
- Edited by david hk129 Thursday, March 16, 2017 11:02 PM
------------------------------------
Reply:
From the reports posted by users in other forums, Watermark is back on.
Did not hear anything about Expiry Date. I would imagine it is back on too.
On build you can disable UUP and still get the new build, next build you cannot.
One build you have no watermark and expiry date, next build you have both.
Will Microsoft please make up their @#%$^!!! mind ?
- Edited by david hk129 Thursday, March 16, 2017 11:04 PM
------------------------------------
Reply:
To those who are facing the following error message as I had, please use the "workaround" posted at the end.
Link to the workaround. It works for me.
------------------------------------
Reply:
------------------------------------
Reply:
These are what happened to my 15060 install.
1. I suspected this issue 3 builds ago, but I was not 100% sure. So, I did not mention it.
I am now sure.
I always have these 4 right click context menus installed on all my computers.............Open With, Copyto, MoveTo and Run as Admin.
Open With remains untouched, the other 3 were removed after 15060 installed. I had to re-install them
2. sfc /scannow .............. found corrupt files but unable to repair some of them.
3. dism /online /cleanup-image /restorehealth .............. source files not found.
4. Because I did not bother to create UUPtoISO, I cannot run the dism with source appended. I bet it would not complete either.
------------------------------------
Windows server converted P2V through DISK2VHD not working
HI Team,
i converted a windows server to P2V through DISK2VHD,when i start the vhd in hyper v i get the below screen.
TechGUy,System Administrator.
Reply:
Hi,
This issue seems to be window server problem related. I suggest to post it on Window Server Forum for better help.
https://social.technet.microsoft.com/Forums/exchange/en-US/home?forum=winserverhyperv
Best Regards,
Lynn-Li
TechNet Community Support
Please remember to mark the replies as answers.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
------------------------------------
IP port selection for our multi-tenant, many-instance, AOAG environment. Your thoughts?
Hi all,
We run an environment with several multi-node clusters and standalone instances. These host databases for internal use, managed/provided services and for customers (and their other vendors). Obviously there is some significant disparity in access and isolation requirements between these different environments - some do share clusters (even instances) and others are entirely isolated (own cluster or instance).
Because of this disparity we've opted to for a policy regarding port selection roughly as follows...
- Random port number between 10,000 and 65,000
- No repeating digits
- No allocation of sequential port numbers (e.g., 80033, 80034, 80035, etc)
- Port numbers must be unique across all our SQL Servers/listeners
Now I guess this might seem like overkill to some.
So why did we go to this extreme?
First there's the old issue of incorrect connections. Previously we have had issues with staff, customers and vendors getting their connections mixed up. A real example (with the names changed to protect the guilty) is Todd thinking he is connected to development instance custdev1,12345 he is actually connected to production instance custprod1,12345. Todd goes on to trash a whole bumnch of data, causing a customer outage and lost data while we recover to the point in time he went on his little spree. This can happen because Todd connected using the IP address or because he made a copy-paste error or a typo or other human error or even through simple ignorance. This approach has definitely helped with this problem.
Second of course there's security. Being off port 1433 is pretty strongly recommended by most security groups and many of us remember the chaos that Slammer caused in our environments. I could also argue that using disparate ports in our environment makes simple IP probing much harder. Yes I know, some folks will cry "port scanning". But our intrusion prevention software makes that a moot point in our environment.
Of course, certain developers and support folk don't like having to deal with changing the port like this. I guess it makes a little extra work for them and as a result we now need to make a case for our decisions, or risk them being overridden.
So, I am interested in hearing the thoughts of other DBAs and architects (and MS staff) experienced in these kind of disparate environments.
Have we made bad calls? Good calls? Why?
Are you aware of any standards or other documentation that provide significant support or opposition to this kind of approach?
All honest thoughts and feedback greatly appreciated!
Thanks in advance,
Doug
- Changed type Lydia ZhangMicrosoft contingent staff Thursday, March 30, 2017 8:26 AM
Reply:
Different accounts in prod, uat and dev go a long way to prevent these sorts of data corruption issues. A dev login will only exist in dev, if someone using the dev login tries to login to production or uat their login will fail.
I don't recommend the use of IP to connect to resources as it is too easy to make the kinds of mistakes you are making. On some environments I work on the use of the server is embedded in the name, like NTUSNYCUAT94. 94 is the last octet of the ip address.
On most environments I work in which are insulated from the outside world we use port 1433, on the public facing ones we use different ports. Keep in mind that by using a random port for SQL Server to run on you are merely raising the bar ever so slightly for hackers who are probing your network looking for ports which are responding.
I have been recently being using tools which can carve out virtual environments which are isolated from the lan segment that the rest of the company works on. Veeam allows you to quickly provision test, dev and uat environments. Dephix can take a Sql backup and mount it in a different environment as well. I know one pharmaceutical who does all their dev and uat in the cloud, to enable rapid provisioning, and to isolate these environments from the production ones.
- Edited by Hilary CotterMVP Thursday, March 16, 2017 12:30 AM
------------------------------------
Reply:
Completely my person opinion:
I'm with Hilary. Use accounts, not port number to restrict access and "oops" moments. Glad it worked for you, so far, though.
>Yes I know, some folks will cry "port scanning". But our intrusion prevention software makes that a moot point in our environment.
Meh. You don't even need to port scan TBH - just look at the packets for TDS. Well, that was easy and your IPS won't even throw an alarm.
I sincerely despise the argument for changing ports for "security" as it's a false hope at best and a horrible connection string nightmare at the worst. If it doesn't face the internet - 1433. If it directly faces the internet then you're doing it wrong (IMHO).
I could also ask Active Directory... It's even easier since you're using clusters.
>many of us remember the chaos that Slammer caused in our environments.
Blaming a resolution protocol (UDP 1434 which does port lookup) for a host directly visible to the internet by using a different TCP/IP port number is a fairly weak argument since you'd still be infected with the different port number.
Bottom line...
I would *personally* hate this setup, I would feel as though I'm in my own personal hell. Use proper firewalls with host restrictions, logins and restrictions, etc., but don't use port numbers for any level of protection. Use different port numbers if the instances are stacked - sure, no problem there.
I couldn't make a good argument for using it but could make many counter arguments for not using it.
The views, opinions, and posts do not reflect those of my company and are solely my own. No warranty, service, or results are expressed or implied.
------------------------------------
Reply:
Thanks for your response Hilary!
Different accounts in prod, uat and dev go a long way to prevent these sorts of data corruption issues. A dev login will only exist in dev, if someone using the dev login tries to login to production or uat their login will fail.
And of course we can't use domain authentication then. SQL logins come with a bunch of other problems. That said we actually do use logins for separation too. People still manage to connect to the wrong listener, but to the right database. Until there's a failover. Then they phone up very angry (or raise a ticket) and we say "what are you connecting to?". They get very quite once they check.
We find is very effective with "service account" logins. Though a small number of products can't use a different DB login in the different environments :-\
I don't recommend the use of IP to connect to resources as it is too easy to make the kinds of mistakes you are making. On some environments I work on the use of the server is embedded in the name, like NTUSNYCUAT94. 94 is the last octet of the ip address.
I vigorously tell people not to use IP addresses. Based on everything else I have posted do you think they listen? No. And they get themselves into trouble. And we still have to pick up the peices... And of course we get the blame lol
On most environments I work in which are insulated from the outside world we use port 1433, on the public facing ones we use different ports. Keep in mind that by using a random port for SQL Server to run on you are merely raising the bar ever so slightly for hackers who are probing your network looking for ports which are responding.
Sure, as a security measure its not hugely big. We aren't public facing but we do have some mixed internal vlans.
I have been recently being using tools which can carve out virtual environments which are isolated from the lan segment that the rest of the company works on. Veeam allows you to quickly provision test, dev and uat environments. Dephix can take a Sql backup and mount it in a different environment as well. I know one pharmaceutical who does all their dev and uat in the cloud, to enable rapid provisioning, and to isolate these environments from the production ones.
We do some similar things with our subnets. But there are cases where there isn't network separation. Unfortunately those tools aren't something we are likely to see in the near future.
Regards,
Doug
------------------------------------
Reply:
Thanks for your response Sean!
Completely my person opinion:
I'm with Hilary. Use accounts, not port number to restrict access and "oops" moments. Glad it worked for you, so far, though.
As per my response to Hilary we use that as well. At least, where we aren't using domain authentication.
>Yes I know, some folks will cry "port scanning". But our intrusion prevention software makes that a moot point in our environment.
Meh. You don't even need to port scan TBH - just look at the packets for TDS. Well, that was easy and your IPS won't even throw an alarm.
Sorry, how do you scan TDS streams for an instance you don't connect to? Besides Wireshark or similar, which won't function in our networks except for authorised workstations.
I sincerely despise the argument for changing ports for "security" as it's a false hope at best and a horrible connection string nightmare at the worst. If it doesn't face the internet - 1433. If it directly faces the internet then you're doing it wrong (IMHO).
Unfortunately we don't get to make the call on 1433. Browser is also off too. I definately agree on internet facing (but ew, why?!). I would imagine that competent app support and coders could handle connect strings. Us DBAs manage it without problems.
I could also ask Active Directory... It's even easier since you're using clusters.
Come again? That's new to me. How and what AD rights do you need?
>many of us remember the chaos that Slammer caused in our environments.
Blaming a resolution protocol (UDP 1434 which does port lookup) for a host directly visible to the internet by using a different TCP/IP port number is a fairly weak argument since you'd still be infected with the different port number.
I remember when Slammer got into the networks I was DBA in years ago. Noone knows quite how as there's no direct access and layers of firewall. It wasn't fun at the time, but strangely enough brings fond memories in hindsight.
Bottom line...
I would *personally* hate this setup, I would feel as though I'm in my own personal hell. Use proper firewalls with host restrictions, logins and restrictions, etc., but don't use port numbers for any level of protection. Use different port numbers if the instances are stacked - sure, no problem there.
I'm just wondering how you partition access for staff using AD authentication across multiple systems?
I couldn't make a good argument for using it but could make many counter arguments for not using it.
Thanks! I greatly appreciate you sharing your thoughts!
Cheers,
Doug
------------------------------------
Reply:
>Sorry, how do you scan TDS streams for an instance you don't connect to? Besides Wireshark or similar, which won't function in our networks except for authorised workstations.
You're expecting people to follow the rules ;) A network packet capture device can be made with about $25 worth of hardware and open source items. All I technically need to do is connect a computer to any wire and grab all the packets - at some point I'll find TDS flowing around.
>And of course we can't use domain authentication then. SQL logins come with a bunch of other problems.
Why not? Production forest, test forest, etc., etc. Developers only have access to dev/test, automation pushes out updates, etc. Why couldn't AD Groups be used here? If it is an organizational reason, I get it (such as you don't use AD but some other LDAP providers, etc).
>Come again? That's new to me. How and what AD rights do you need?
Minimial. In fact most new accounts have all the permissions needed. I'm not going to *tell* you on an open forum how to exploit this information - but look at the object attributes and you'll see how to get an LDAP query to find the information... there may or may not be other steps, but that'll point you in the proper direction. Don't forget, there are services you can also interrogate for the type of service and what port it is on...
>It wasn't fun at the time, but strangely enough brings fond memories in hindsight.
Haha, I understand :)
>I'm just wondering how you partition access for staff using AD authentication across multiple systems?
One way is to do so through JEA and JIA (just enough access and just in time administration) in addition to different forests without trust. I'm not an AD guru (I use it, and that's about the extent of it) so you'll definitely want to speak to others more knowledgeable about the subject on how the best way to do it would be - but this is one of the easiest ways, albeit sometimes it feels drastic.
>Thanks! I greatly appreciate you sharing your thoughts!
Cheers :)
-Sean
The views, opinions, and posts do not reflect those of my company and are solely my own. No warranty, service, or results are expressed or implied.
------------------------------------
Reply:
>You're expecting people to follow the rules ;) A network packet capture device can be made with about $25 worth of hardware and open source items. All I technically need to do is connect a computer to any wire and grab all the packets - at some point I'll find TDS flowing around.
You will find the port non-functional as soon as you disconnect it. You'll have also have a visitor at your desk within 5 minutes checking what you were up to.
>>And of course we can't use domain authentication then. SQL logins come with a bunch of other problems.
>Why not? Production forest, test forest, etc., etc. Developers only have access to dev/test, automation pushes out updates, etc. Why couldn't AD Groups be used here? If it is an organizational reason, I get it (such as you don't use AD but some other LDAP providers, etc).
We use AD but some wonderful bright spark screwed down all the trusts between domains and made every group and user a ".local" one. Kills the trusts for SQL Server - we've burnt a lot of effort trying to get cross-domain authentication working.
>>Come again? That's new to me. How and what AD rights do you need?
>
>Minimial. In fact most new accounts have all the permissions needed. I'm not going to *tell* you on an open forum how to exploit this information - but look at the object attributes and you'll see how to get an LDAP query to find the information... there may or may not be other steps, but that'll point you in the proper direction. Don't forget, there are services you can also interrogate for the type of service and what port it is on...
Interesting. Thanks for that. Yeah services, that I get. Although remote query of services is disabled for everyone here by default. And our AD rights aren't "standard". I'd look into it but I'm scared that what I find will cause our security folks to screw down AD even more.
That's the thing. Trying to demonstrate to them that there are other ways to get what an attacker might be after simply has them mandating to the whole organisation that we have to "plug that hole". The truth is there are trying to plug a collander :-\ It was never supposed to be water-proof at that level.
>>It wasn't fun at the time, but strangely enough brings fond memories in hindsight.
>
>Haha, I understand :)
DBA life, right?
>>I'm just wondering how you partition access for staff using AD authentication across multiple systems?
>
>One way is to do so through JEA and JIA (just enough access and just in time administration) in addition to different forests without trust. I'm not an AD guru (I use it, and that's about the extent of it) so you'll definitely want to speak to others more knowledgeable about the subject on how the best way to do it would be - but this is one of the easiest ways, albeit sometimes it feels drastic.
It actually sounds pretty hard to implement for us. Unfortunately :-(
Cheers,
Doug
------------------------------------
Error query
Hello i have an error on this query, how can "group by" colum by codart and sum only the column Quantita
Reply:
Hello Riki,
Hope below query helps.
--DROP TABLE #TEMPselect *
into #temp from (select '10307' as CodeArt,0.32 as Prezzo , 20 as Quantita, 6.4000 as Totale
union all
select '10307' as CodeArt,0.32 as Prezzo , 1 as Quantita, 0.32000 as Totale
union all
select 'N07-K 6 BLS' as CodeArt,0.32 as Prezzo , 60 as Quantita, 19.4000 as Totale
)a
select Codeart,prezzo,sum(Quantita) as s
from #temp
group by CodeArt,prezzo
Please let me know if you have any questions.
Please Mark this reply as answer if it is helpful. Or please click on up-arrow above the "Vote"
------------------------------------
A quick guide to project deployment
As a newcomer to publishing Visual Studio projects, there were a LOT of things I needed to learn the hard way! I'm indebted to this forum for the help that various experts provided, but I used a lot of their (and my) time in the process. I made a list of notes as I went along, and I attach them below in case they might help anyone else in the position that I was in. I'm sure I've left out lots of things, but at least it's a start!
The 'Publish' facility in Visual Studio is relatively easy to use - but it does not create a desktop shortcut, does not support 'drag-and-drop', and does not (so far as I know) allow you to associate a file extension with your project. Also, the application installs itself in a very obscure location in the user's computer. If these are a problem, you should use Microsofts's Visual Studio Installer.
Install Visual Studio 2015 Installer (available at https://marketplace.visualstudio.com/items?itemName=VisualStudioProductTeam.MicrosoftVisualStudio2015InstallerProjects )and re-start Studio
Add a VSI project to your solution (File > Add > New project) and choose Other Project Types > Visual Studio Installer > Setup Project. (If you forget to set up the installer project name and folder correctly, you'll subsequently have to delete the project, rename the .vdproj file, move it to the correct folder and add it to the sulution again, this time as an existing project.)
Right-click on the new project in Solution Explorer and choose View > File System
Right-click on the Application Folder and add Project Output, the helpfile and the program icon. If you add a file that you want to be read-only, you need to set this in the file's properties in Studio (the file's own properties are ignored).
To make a shortcut on the user's desktop: Left-click on User's Desktop folder, then right-click in the (empty) 'Name' window and choose 'Create new shortcut'. Choose Primary Output from the Application Folder. Set the name and the icon for the shortcut in the Properties window
To associate a file extension with your project: select the setup project and select View > file types, to open file type editor. Enter extension, and select primary output as filename to open.
To reduce unnecessary dependencies: select References under the main project, select any COM dependencies (see Project>Properies>References), and set Embed Interop Types to True. (This means the dependency does not need to be installed as a stand-alone .dll)
Right click on the project in Solution explorer to build it - this puts the output files in a folder called App setup (alongside the .NET folder).
To allow drag-and-drop: right-click on the .msi file, and open it with Orca (which you need to install first). Navigate to the Property table, and right-click to add an entry called DISABLEADVTSHORTCUTS with a value of 1. Then save the msi.
Back in Studio, right click on the project in Solution explorer and use 'install' for testing your installation, as this automatically uninstalls any previous version (necessary because windows uses a cached copy of the older msi file otherwise).
When happy, copy the .msi and setup.exe files to your main installation folder.
(The webpage entitled "Visual Studio Installer Deployment - MSDN - Microsoft" is of some help.)
If it can't be done in Fortran 77 it's not worth doing, IMO
- Moved by Bob Ding Tuesday, March 21, 2017 7:11 AM not a question
Reply:
HI,
we appreciated you shared us your experience. But this forum is a asking and discussing forum. I suggest you create and share your post on an MSDN Blog.
Best Regards,
Bob
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
------------------------------------
Reply:
If it can't be done in Fortran 77 it's not worth doing, IMO
------------------------------------
powershell gui to not close
I found the script listed below but I am having a problem with it. I need it to not close when I press ok so that I can do a few more things within the same GUI window. I am new to powershell so I might be something easy but I can't find a good solution anywhere. I am adding a listbox at the end of this to display messages on the progress of the script but can't get it to stay open.
Add-Type -AssemblyName System.Windows.Forms
Add-Type -AssemblyName System.Drawing
$form = New-Object System.Windows.Forms.Form
$form.Text = "Data Entry Form"
$form.Size = New-Object System.Drawing.Size(300,200)
$form.StartPosition = "CenterScreen"
$OKButton = New-Object System.Windows.Forms.Button
$OKButton.Location = New-Object System.Drawing.Point(75,120)
$OKButton.Size = New-Object System.Drawing.Size(75,23)
$OKButton.Text = "OK"
$OKButton.DialogResult = [System.Windows.Forms.DialogResult]::OK
$form.AcceptButton = $OKButton
$form.Controls.Add($OKButton)
$CancelButton = New-Object System.Windows.Forms.Button
$CancelButton.Location = New-Object System.Drawing.Point(150,120)
$CancelButton.Size = New-Object System.Drawing.Size(75,23)
$CancelButton.Text = "Cancel"
$CancelButton.DialogResult = [System.Windows.Forms.DialogResult]::Cancel
$form.CancelButton = $CancelButton
$form.Controls.Add($CancelButton)
$label = New-Object System.Windows.Forms.Label
$label.Location = New-Object System.Drawing.Point(10,20)
$label.Size = New-Object System.Drawing.Size(280,20)
$label.Text = "Please enter the information in the space below:"
$form.Controls.Add($label)
$textBox = New-Object System.Windows.Forms.TextBox
$textBox.Location = New-Object System.Drawing.Point(10,40)
$textBox.Size = New-Object System.Drawing.Size(260,20)
$form.Controls.Add($textBox)
$form.Topmost = $True
$form.Add_Shown({$textBox.Select()})
$result = $form.ShowDialog()
if ($result -eq [System.Windows.Forms.DialogResult]::OK)
{
$x = $textBox.Text
$x
}
- Changed type Bill_Stewart Thursday, June 23, 2016 10:19 PM
- Moved by Bill_Stewart Thursday, June 23, 2016 10:19 PM This is not "train me in basics of GUI development" forum
Reply:
This thread on stack exchange seems similar
http://stackoverflow.com/questions/9362722/stop-powershell-from-exiting
Another option would be to, instead of right clicking it and saying 'run with powershell' to instead open powershell and then tell it to run that script.
http://stackoverflow.com/questions/2035193/how-to-run-a-powershell-script
- Edited by Alex Brassington Monday, May 16, 2016 4:02 PM
------------------------------------
Reply:
The powershell will still run, but The GUI closes and I don't want that.
- Edited by Johnny t 1339 Monday, May 16, 2016 4:54 PM
------------------------------------
Reply:
What do you want the Ok button to do? Maybe you should just remove the OKButon.
\_(ツ)_/
- Edited by jrv Monday, May 16, 2016 5:53 PM
------------------------------------
Reply:
I have four fields above it that I would enter information into and a list box below it. I want it so that when I press ok that it goes to the rest of the script (not listed above) but doesn't close the GUI. The fields fill in variables for the rest of the script.
The list box under is to fill in information on what the script is currently doing.
- Edited by Johnny t 1339 Monday, May 16, 2016 5:56 PM
------------------------------------
Reply:
I have four fields above it that I would enter information into and a list box below it. I want it so that when I press ok that it goes to the rest of the script (not listed above) but doesn't close the GUI. The fields fill in variables for the rest of the script.
The list box under is to fill in information on what the script is currently doing.
Can't be done. The line $form.ShowDialog is blocking. The form must close for the script to continue. In forms we generally place all processing inside of the form when we want to reuse the form.
\_(ツ)_/
------------------------------------
Reply:
------------------------------------
Reply:
What would be the best way to change it to make it work?
What does "make it work" mean? It works. It just has to close before the rest of you script will run. If you want it to do something else you will have to write code to do what you want. We cannot guess at hat that is.
\_(ツ)_/
------------------------------------
Reply:
------------------------------------
Reply:
What method for this form should I use to make a GUI that won't close until I want it to or is there a part in this code that I can move to make it not close until the end?
No idea what you are asking. All form code must run inside of a form event. Any event that is generated by the form can have code associated. This is how Windows works.
Here is a discussion on how to design and use forms with PowerShell: https://www.sapien.com/blog/topics/user-interface-design-for-administrators/
Start with "User interface design for administrators" at the bottom of the list.
\_(ツ)_/
------------------------------------
Reply:
------------------------------------
Reply:
Hello Johnny,
i also need same thing, so what did you do to keep the GUI open ?
event handler to be added instead of an OK button , can you please help me with this code?
Below is my code, it works fine but closes the moment i click OK button, but does its job,
==================================================================
[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")
[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Drawing")
[System.Windows.Forms.FormClosingEventHandler]
Clear-History
Clear-Host
$currentdir = (Get-Location).Path
$logpath = "C:\Development_Zone\Applications taging"
# Erase existing input & output
Remove-Item -Path "$currentdir\output.csv" -Force -ErrorAction SilentlyContinue -WarningAction SilentlyContinue
Remove-Item -Path "$currentdir\Applications.txt" -Force -ErrorAction SilentlyContinue -WarningAction SilentlyContinue
New-Item -Path "$currentdir\output.csv" -ItemType file -Force | out-null
New-Item -Path "$currentdir\Applications.txt" -ItemType file -Force | out-null
Remove-Item -Path "$currentdir\collections.csv" -Force -ErrorAction SilentlyContinue -WarningAction SilentlyContinue
New-Item -Path "$currentdir\collections.csv" -ItemType file -Force | out-null
add-content -path "$currentdir\collections.csv" -Value "CollectionName,CollectionID" -Force -WarningAction SilentlyContinue -ErrorAction SilentlyContinue
$SiteCode="DCA"
$SCCMServer="XXX.com"
# Get a list of collections and find the object to build the collection list.
$Collections = (Get-WmiObject -ComputerName $SCCMServer -Namespace "root\sms\site_$SiteCode" -Class 'SMS_Collection' | Select-Object Name,CollectionID)
foreach($Collection in $Collections)
{
$cn = $Collection.Name;
$CID = $Collection.CollectionID;
$output = -join ($cn +","+$CID)
Add-Content -Value $output -Path "$currentdir\collections.csv" -Force -ErrorAction SilentlyContinue -WarningAction SilentlyContinue
}
[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms")
[void] [System.Reflection.Assembly]::LoadWithPartialName("System.Drawing")
Clear-History
Clear-Host
$backcolour = [System.Drawing.Image]::Fromfile((get-item 'C:\Development_Zone\Applications taging\Logo_Pic.png'));
$objForm = New-Object System.Windows.Forms.Form
$objForm.Text = "Software Staging Tool"
$objForm.Size = New-Object System.Drawing.Size(1700,850)
$objForm.BackColor = "White"
$objForm.StartPosition = "CenterScreen"
# Got rid of the block of code related to KeyPreview and KeyDown events.
$OKButton = New-Object System.Windows.Forms.Button
$OKButton.Location = New-Object System.Drawing.Size(310,500)
$OKButton.Size = New-Object System.Drawing.Size(75,23)
$OKButton.Text = "OK"
# Got rid of the Click event for the OK button, and instead just assigned its DialogResult property to OK.
$OKButton.DialogResult = [System.Windows.Forms.DialogResult]::OK
$objForm.Controls.Add($OKButton)
# Setting the form's AcceptButton property causes it to automatically intercept the Enter keystroke and
# treat it as clicking the OK button (without having to write your own KeyDown events).
$objForm.AcceptButton = $OKButton
$CancelButton = New-Object System.Windows.Forms.Button
$CancelButton.Location = New-Object System.Drawing.Size(390,500)
$CancelButton.Size = New-Object System.Drawing.Size(75,23)
$CancelButton.Text = "Cancel"
# Got rid of the Click event for the Cancel button, and instead just assigned its DialogResult property to Cancel.
$CancelButton.DialogResult = [System.Windows.Forms.DialogResult]::Cancel
$objForm.Controls.Add($CancelButton)
# Setting the form's CancelButton property causes it to automatically intercept the Escape keystroke and
# treat it as clicking the OK button (without having to write your own KeyDown events).
$objForm.CancelButton = $CancelButton
$objLabel = New-Object System.Windows.Forms.Label
$objLabel.Location = New-Object System.Drawing.Size(350,168)
$objLabel.Size = New-Object System.Drawing.Size(280,25)
$objLabel.Text = "Please select Collection:"
$objForm.Controls.Add($objLabel)
# to adjust the blue background
$objListBox = New-Object System.Windows.Forms.ListBox
$objListBox.Location = New-Object System.Drawing.Size(120,200)
$objListBox.Size = New-Object System.Drawing.Size(600,1100)
$objListBox.Height = 300
$objListBox.BackColor = "cyan"
$objListBox.Forecolor = "Blue"
$objListBox.Font = "Arial Black"
$objListbox.SelectionMode = "MultiSimple"
########### Info Box Field
$outputBox = New-Object System.Windows.Forms.RichTextBox
$outputBox.Location = New-Object System.Drawing.Size(55,535)
$outputBox.Size = New-Object System.Drawing.Size(770,110)
$outputBox.Font = New-Object System.Drawing.Font("Lucida Console",16)
$outputBox.ForeColor = [Drawing.Color]::Green
$outputBox.MultiLine = $True
$outputBox.ReadOnly = $True
$outputBox.ScrollBars = "Vertical"
$outputBox.Text = " This tool will help you to Stage Applications, Hardware Drivers, Software Updates, Task Sequence from Development Environment to Production Environment."
$objForm.Controls.Add($outputBox)
############################################## end text fields
# To Display Logo
########### PictureBox Label
$PictureBoxLabel = New-Object System.Windows.Forms.Label
$PictureBoxLabel.Text="Current Logon Screen"
$PictureBoxLabel.Visible = $False
$PictureBoxLabel.Location = New-Object System.Drawing.Size(20,10)
$PictureBoxLabel.Size = New-Object System.Drawing.Size(30,50)
$objForm.Controls.Add($PictureBoxLabel)
########### Input PictureBox
$defbackground = [System.Drawing.Image]::Fromfile((get-item "$currentdir\Logo.png"));
$PictureBox = New-Object System.Windows.Forms.PictureBox
$PictureBox.Location = "680, 20"
$pictureBox.Width = 158
$pictureBox.Height = 90
#$PictureBox.ClientSize = "480, 300"
$PictureBox.Image = $defbackground
#$PictureBox.BackColor = "Black"
$PictureBox.SizeMode = "Zoom"
$objForm.Controls.Add($PictureBox)
#Drop Down to select Field Test / Production
$objLabel2 = New-Object System.Windows.Forms.Label
$objLabel2.Location = New-Object System.Drawing.Size(320,90)
$objLabel2.Size = New-Object System.Drawing.Size(200,20)
$objLabel2.Text = "Rollout Out to Field Test/ Production:"
$objForm.Controls.Add($objLabel2)
[array]$DropDownArray2 = "Field Test", "Production" , "10 % Rollout"
$DropDown2 = new-object System.Windows.Forms.ComboBox
$DropDown2.Location = new-object System.Drawing.Size(350,115)
$DropDown2.Size = new-object System.Drawing.Size(130,30)
ForEach ($Item2 in $DropDownArray2) {
$DropDown2.Items.Add($Item2)
}
$objForm.Controls.Add($DropDown2)
$DropDownLabel2 = new-object System.Windows.Forms.Label
$DropDownLabel2.Location = new-object System.Drawing.Size(10,10)
$DropDownLabel2.size = new-object System.Drawing.Size(100,20)
$DropDownLabel2.Text = $args
$args = $server
$objForm.Controls.Add($DropDownLabel2)
#Drop Down to select HW / SW
$objLabel = New-Object System.Windows.Forms.Label
$objLabel.Location = New-Object System.Drawing.Size(265,20)
$objLabel.Size = New-Object System.Drawing.Size(480,20)
$objLabel.Text = "Type of Package Hardware/Application/Task Sequence:"
$objForm.Controls.Add($objLabel)
[array]$DropDownArray = "Hardware", "Application", "Task Sequence", "Software Update"
$DropDown = new-object System.Windows.Forms.ComboBox
$DropDown.Location = new-object System.Drawing.Size(350,45)
$DropDown.Size = new-object System.Drawing.Size(130,30)
ForEach ($Item in $DropDownArray) {
$DropDown.Items.Add($Item)
}
$objForm.Controls.Add($DropDown)
$DropDownLabel = new-object System.Windows.Forms.Label
$DropDownLabel.Location = new-object System.Drawing.Size(10,10)
$DropDownLabel.size = new-object System.Drawing.Size(100,20)
$DropDownLabel.Text = $args
$args = $server
$objForm.Controls.Add($DropDownLabel)
#Add the new user to the default groups
$csvim = import-csv -Path "$currentdir\collections.csv"
$csvim.CollectionName | Sort-Object | ForEach-Object {[void] $objListBox.Items.Add($_)}
$objForm.Controls.Add($objListBox)
$objForm.Topmost = $True
$result = $objForm.ShowDialog()
# Field test / Production result
#$Form.Close()
$result4 = $null
if ($DropDown2.SelectedItem -eq $null)
{
$outputBox.text= " Please Select a Value from the Drop Box to Continue"
pause
}
elseif ($DropDown2.SelectedItem -eq "Field Test")
{
$result4 = "-FT $"+"true"
}
elseif ($DropDown2.SelectedItem -eq "Production")
{
$result4 = "-RuleSet $"+"true"
}
elseif ($DropDown2.SelectedItem -eq "10 % Rollout")
{
$result4 = "Ten"
}
# This Function Returns the Selected Value and their actions then Closes the Form
#$Form.Close()
$result3 = $null
if($DropDown.SelectedItem -eq $null)
{
$outputBox.text = "Please Select a Value from the Drop Box to Continue"
pause
}
if ($DropDown.SelectedItem -eq "Hardware")
{
$result3 = "HW"
}
elseif ($DropDown.SelectedItem -eq "Application")
{
$result3 = "SW"
}
elseif ($DropDown.SelectedItem -eq "Task Sequence")
{
$result3 = "TS"
}
$i = 0
if(($DropDown.SelectedItem -ne $null) -and ($DropDown2.SelectedItem -ne $null))
{
foreach ($objItem in $objListbox.SelectedItems)
{$ok = $objItem
$final = -join ("$ok"+","+"$result3"+","+"$result4")
$final | Out-File "$currentdir\output.csv" -Encoding ascii -Append
#CloneCollection -SourceCollectionName "$ok" -TargetStage "PCA:" -SourceStage "DCA:" -StageMode $result3 -RuleSet $true
$i++
}
}
$output2 = import-csv -Path "$currentdir\output.csv"
$outputBox.text= "final step"
Start-Sleep 7000
# Do something with $selection
$objForm.Close()
Read-Host -Prompt "Press Enter to exit"
Clear-Host
OSLM ENGINEER - SCCM 2007 & 2012
------------------------------------
Reply:
You keep posting large blocks of code on many forums. Pleas don't do this. T posted the answer on tour original thread.
Please look at the title of this topic. It is not in use and not a place to post.
This topic:
Using Forums >\_(ツ)_/
------------------------------------
registry
Hi Experts
On few of my servers, i need to add registry entries remotely. Please guide me using script, i cannot go by gpo as i have servers spread over various ou's
i have a registry entry by name exclude under (HKEY_LOCALMACHINE\SOFTWARE\MYAPPLICATION\CONFIG) and i need to add few entries like *.xyz , C:\xyz in the exclude registry. I am trying with script can any expert help me on this.
$Servers = Get-Content "C:\Servers.txt"
$TotalServersCount = ($Servers).Count
$PerCentageCounter = 1
Foreach ($Server IN $Servers) {
$PerCentCompleted = [System.Math]::Round(($PerCentageCounter/$TotalServersCount*100),0)
Write-Progress -Activity "Processing Server [$PerCentageCounter] [$Server]" -CurrentOperation "Checking Connectivity to the Server"
# Check Ping Connection to the Server
if (! (Test-Connection -ComputerName $Server -Count 2 -ErrorAction SilentlyContinue -Quiet)) {
Write-Warning "Ping check failed for $Server, Skipping Server"
Write-Progress -Activity "Ping check failed for $Server, Skipping Server" -Status "$PerCentCompleted% Complete:" -PercentComplete $PerCentCompleted
Start-Sleep -Seconds 5
$PerCentageCounter++
Continue
}
Write-Progress -Activity "Processing $Server Server" -CurrentOperation "Updating Registry Value"
# Adding software exclusion
REG ADD "\\$Server\HKEY_LOCALMACHINE\SOFTWARE\MYAPPLICATION\CONFIG"
- Changed type Bill_Stewart Friday, April 28, 2017 7:51 PM
- Moved by Bill_Stewart Friday, April 28, 2017 7:51 PM This is not "scripts on demand"
Reply:
Read this first:
This forum is for scripting questions rather than script requests
-- Bill Stewart [Bill_Stewart]
------------------------------------
Reply:
This can be done by GPO and it is the only way you should be doing it.
Post in GP forum to learn how to use GP to assign and maintain registry values.
\_(ツ)_/
------------------------------------
Does installing OMS agents on Windows servers require a reboot?
- Changed type Bill_Stewart Friday, April 28, 2017 7:50 PM
- Moved by Bill_Stewart Friday, April 28, 2017 7:51 PM Off-topic
Reply:
You're not asking in the right place. This is a scripting forum.
-- Bill Stewart [Bill_Stewart]
------------------------------------
Microsoft Suspends Windows 7/8.1 Updates For Intel Kaby Lake & AMD Ryzen CPUs
MDX: Except that i need to total sales amount in particular year
SELECT
{[Measures].[Internet Sales Amount]} ON 0,
{[Date].[Calendar].[Month].&[2008]&[2]} ON 1
FROM [Adventure Works]
WHERE [Date].[Calendar Year].&[2008]
--$47,868.54 (For FEB month 29th SalesAmount)
SELECT
{[Measures].[Internet Sales Amount]} ON 0,
{[Date].[Calendar].[Date].&[20080229]} ON 1
FROM [Adventure Works]
WHERE [Date].[Calendar Year].&[2008]
--Here how to exclude the FEB month 29th SalesAmount in that Particular Year
SELECT
{[Measures].[Internet Sales Amount]} ON 0,
EXCEPT(
[Date].[Calendar].[Month],
{[Date].[Calendar].[Date].&[20080229]}
)
ON 1
FROM [Adventure Works]
WHERE [Date].[Calendar Year].&[2008]
Reply:
this can be achieved with a subselect:
SELECT
{[Measures].[Internet Sales Amount]} ON 0,
{[Date].[Calendar].[Month].&[2008]&[2]} ON 1
FROM (
SELECT -{[Date].[Calendar].[Date].&[20080229]} ON 0
FROM [Adventure Works])
WHERE [Date].[Calendar Year].&[2008]
however, it would be much easier if you create a new Attribute in your DAte-Table and Flag the 29th of February there. In the query you can then simply use [Date].[IsFeb29].&[0] and it will work for all years
hth,
-gerhard
Gerhard Brueckl
blogging @ http://blog.gbrueckl.at
working @ http://www.pmOne.com
------------------------------------
Question regarding Outlook Anywhere over an MPLS connection..
Hi,
I currently have a latency issue between head office site where a Exchange 2010 server is located and a remote site (connected by an MPLS line). The latency issue is being dealt with by the MPLS provider, but in the meantime I would like to force Outlook clients at the remote site to connect to the Exchange server using their Internet connection and not the MPLS line.
Under the Outlook Anywhere settings, will ticking the option 'On fast/slow networks, connect using HTTP first, the connect using TCP/IP' force the connection to use the Internet connection or the MPLS line?
Or would it require some routing on the MPLS provider's router to force traffic from Outlook clients to go over the Internet line and not the MPLS?
Thanks,
Reply:
Will Martin ...
-join ('77696c6c406d617274696e2d66616d696c6965732e6f7267' -split '(?<=\G.{2})' | ? { $_ } | % { [char][int]"0x$_" })
------------------------------------
Reply:
------------------------------------
Lync PSTN integration
Reply:
I would not recommend to put the Mediation server in the DMZ. You should put a SBC there and open the firewall ports between SBC and Frontendpool/ Mediation Server for the PST communication.
If you dont want to buy a SBC you can ask your SIP provider if you can do direct SIP
- Edited by Joerg Burmann Thursday, March 16, 2017 2:37 PM
------------------------------------
How to delete archive files, Keeping last 5 days.
Hi,
Could anyone help me , How to delete archive files keeping last 5days.
I was trying to use file system task and taking operation delete and trying to give expression over there.
Is this process helps me ? If yes, could some one suggest me the expression way.
Thanks,
prabha
Reply:
You may want to use this:
http://www.patrickkeisler.com/2012/11/how-to-use-xpdeletefile-to-purge-old.html
You can run this in a SQL Task.
------------------------------------
Reply:
Hi,
Could anyone help me , How to delete archive files keeping last 5days.
I was trying to use file system task and taking operation delete and trying to give expression over there.
Is this process helps me ? If yes, could some one suggest me the expression way.
Thanks,
prabha
Yes
It would help
You can use Script Task to check the created or modified date of files and select only the files created before last 5 days. You can use a conditional precedence constraint for that. Then use a File System Task to delete the file
Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page
- Edited by Visakh16MVP Wednesday, March 15, 2017 5:53 PM
------------------------------------
Reply:
Thanks for your responce Hilary. Could you please let me know instead of Script task , Can I proceed with file system task ? If yes, How can I give expression over there using variable ?
Please, Let me know. Thanks
prabha
------------------------------------
Reply:
------------------------------------
Reply:
prabha
------------------------------------
Reply:
There is no built in way to do that in SSIS. You will need to use a Script Task and code it.
------------------------------------
Reply:
------------------------------------
Reply:
prabha
------------------------------------
Reply:
Yeah , even I was trying same link . varFileFQN , Does they took each file name address in the value name ? Could you please let me know how they used that variable ?
prabha
Why not use file attributes like modified date to identify old files? You can get it easily using a script task
http://microsoft-ssis.blogspot.in/2011/03/get-file-properties-with-ssis.html
Then its all a matter of using expression based precedence constraint to get only old files
Please Mark This As Answer if it solved your issue
Please Vote This As Helpful if it helps to solve your issue
Visakh
----------------------------
My Wiki User Page
My MSDN Page
My Personal Blog
My Facebook Page
------------------------------------
Reply:
Here is a simple script to do what you want on an entire directory.
http://www.sqlideas.com/2011/12/delete-files-older-than-retention_30.html
------------------------------------
Reply:
------------------------------------
Reply:
Thank you Tom, It's helped me.
Thnak you Hilary , for your prompt responses.
Thank you every one.
prabha
------------------------------------
Reply:
Phil Streiff, MCDBA, MCITP, MCSA
------------------------------------
Reply:
prabha
------------------------------------
Unable to create Mailbox in my exchange 2010 and 2013 coexistence environment getting (Unable to create Exchange Mail boxe in Exchange 2010 sp3)
Hi
When I am trying to create a mailbox in my exchange environment getting the below error .
a parameter cannot be found that matches parameter name 'alias' which is not allowing me to create new mailboxes in the exchange environment .could you please assist me with this.
-Mahesh
Reply:
- How are you attempting the action?
- Where are you attempting to do the action
Search, Recover, Export Mailboxes, Folders, Email, Contacts, Calendars, Tasks, etc. from Offline Exchange Databases (EDBs), On-Premise Exchange Servers and Office 365. Migrate/Recover direct from any offline EDB into any On-Premises Exchange Server, even cross version i.e. 2003 → 2007 → 2010 →2013 → 2016 → Office 365 with Lucid8's DigiScope
------------------------------------
No comments:
Post a Comment