How to Create SCCM Collection for SQL Servers! — Transcript

Full transcript

1. 0:02What’s going on, guys?
2. 0:04It is Bernardo, and today is all about creating
3. 0:07a SCCM collection for your SQL servers.
4. 0:12So let’s get right into it.
5. 0:13All right, So today is a really simple video for you guys.
6. 0:16And we are going to launch our SCCM
7. 0:20configuration manager, right or Microsoft Configuration Manager.
8. 0:24Just open it up.
9. 0:24And on your left hand side, we are going to locate device collections.
10. 0:28Click on that excellent.
11. 0:29You’re going to right click on it
12. 0:31and we are going to select create device collection.
13. 0:35Go for it. Do it now. Awesome.
14. 0:37You’re going to get the wizard.
15. 0:39Let’s give it a name.
16. 0:40I’m going to give it this pretty self-explanatory.
17. 0:43All Microsoft SQL servers.
18. 0:46We’re going to click on Browse
19. 0:49and I am going to select all desktop and server clients.
20. 0:53Now this is really up to you.
21. 0:55I should of done all servers because SQL is a server is not a desktop,
22. 1:00but I’ve seen in places that you know, SQL Server, right,
23. 1:06the program, the application was actually installed on a Windows
24. 1:0910 or Windows 11 machine it’s crazy, but for this video I’m
25. 1:13going to do all desktop and server clients we’re going to select.
26. 1:17Okay, awesome.
27. 1:19Click next here and we’re going to click on
28. 1:23Add Rule and we’re going to select query rule.
29. 1:27Select that.
30. 1:27Awesome From here. Let’s give it a name.
31. 1:30We’re going to locate and click on.
32. 1:32Edit query statement. Awesome.
33. 1:35Now from here, we’re going to click on the second tab, which is the criteria.
34. 1:40Now within the criteria tab on the lower left hand side, we’re
35. 1:44going to click on show query language and we’re going to get this.
36. 1:49I am going to basically paste the following.
37. 1:51Now your probably saying to yourself, Bernardo, you know, what are you pasting?
38. 1:55This right here is basically a SQL
39. 1:58query that allows us to go into the database
40. 2:02to grab anything that is SQL Server centric.
41. 2:06That’s what we want.
42. 2:07If you want, you are able to actually click on the play button
43. 2:12and it’s going to launch this and click one run
44. 2:16and then boom, This is a good way to test out that statement,
45. 2:19whether or not it’s going to pick up the databases
46. 2:22within your network, which is great for us.
47. 2:24It picked up BJ Dash SQL and that is my database server.
48. 2:29Awesome. Let’s click on Close.
49. 2:31Let’s click on, Okay, let’s click on, Okay.
50. 2:35And that’s click on next.
51. 2:37Awesome. Click next here and close it.
52. 2:41Now give it some time.
53. 2:42What’s going to happen is your collection should show members count
54. 2:46if you have multiple SQL servers within your network, that number will go up.
55. 2:51I only have one and that’s the reason why there’s one. Now.
56. 2:54If you don’t want to do all SQL servers and you want to break it down
57. 2:59to the version like 2016, 2019, 2022,
58. 3:03don’t worry, here are all the commands.
59. 3:07The one that’s highlighted.
60. 3:08This one will only pick the server 2022.
61. 3:13The third one would pick server 2019 and the last one will be 2017.
62. 3:19Now, if you have 2016, all you got to do is just it’s the same command.
63. 3:23Nothing’s changed.
64. 3:23The only thing that I’m changing is the year, that’s it, and hopefully
65. 3:27you guys enjoy this video and I catch you guys on the next one peace out.